OzGrid Free Excel/VBA Help Forum

Hi CO,

Not sure if this does what you are after, the first only works on the target, the second works through the range depending which range changed.

(Code, 19 lines)

OR
(Code, 23 lines)

HTH
Justin

Hello everyone!

I am new to the forums here and looking into learning more about excel/google sheets. I am currently working on a custom spreadsheet budget. I have a tab with my monthly expenses and I have another tab for my transactions. I would like to…

Ok, I think I may have figured it out for the most part. The links are immediately available in column A, however the column C links require clicking in the cell then off the cell to activate the link. What am I missing?

(Code, 48 lines)

mikerickson I am fascinated with your NextChoice function, it's ingenious! is there a way of looping in this pattern?

Sorry I misunderstood what you meant.

(Code, 70 lines)

I would not recommend using a message box to display the missing Acc. IDs, your sample file has 43 Account IDs in FDG Accounts that do not appear in Client Bill Info, that would be too long a list for…

For me work this:

(Code, 8 lines)

Good afternoon, I'm having trouble getting a SQL string that integrates into 2 different comboboxes by pulling data from access, I'm falling into an infinite loop and I'm not able to solve it, can anyone help me?. Here is the code

(Code, 9 lines)

This is not true. I merely needed to use Cstr() with the value as I documented an update to my initial questions with the working code. I still do not think it is grabbing unique values though, that is values that are in WB1 that are NOT in WB2. Any…

(Quote)

In that case an Account ID in FDG Accounts is never going to be matched in Client Bill Info.

You need to have Account ID formatted the same in both sheets.

I have code that takes the value of a cells in a single column and then uses that value to create a hyperlink within that same cell. It works with the code below. However I'm at a loss to do the same thing with two different columns on the same…