-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
with
-
M
Changing a ComboBox reference using a Variable
Hey there, I am trying to create a code where I can do do the following With command for a ComboBox where it uses a variable to change the ComboBox name. Currently it is: With Sheet1.ComboBox1 .AddItem Sheet1.Range("B" & i).Value End With But I would like it to be...- Muggles
- Thread
- combobox object with
- Replies: 5
- Forum: Excel Questions
-
C
Code not doing anything (no errors)
Hi, Sorry for two posts about the same thing, won't let me delete the first one. I want to create a VBA code so that I can look up the string "Category 1" and use it as a reference to add a certain number of columns based on another cells value. The new cell values are to have the headings...- CluelessAboutExcel
- Thread
- find find & offset offset range vba with
- Replies: 1
- Forum: Excel Questions
-
I
FormulaR1C1 + Error 1004
Hi, I have written some code that looks for column headings to locate the columns of data required in my formula, thus returning a column number. So logically the best method of creating my formula in the cell is to use the FormulaR1C1 function in vba, however I have been unsuccessful in getting...- itsme0481
- Thread
- error error #1004 forecast index match r1c1 r1c1 formula variables with
- Replies: 2
- Forum: Excel Questions
