| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox generic reference
I have a series of comboboxes in a sheet (REFI1, REFI23 etc). How can I make
the second line of code generic (i.e pass the value of rw into Me.REFI & rw)? Dim rw As Long: rw = 51 Range("AG" & rw) = Me.REFI51 I tried: Range("AG" & rw) = Me.REFI & rw but it debugs with "REFI" data member not found. Thanks in advance, Brett. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combobox.value reference | Excel Programming | |||
| Dynamic ComboBox Reference | Excel Programming | |||
| Generic reference in a Macro | Excel Discussion (Misc queries) | |||
| Reference A Combobox On The First page. | Excel Programming | |||
| Generic ComboBox change event | Excel Programming | |||
Threaded Mode
