| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in adding item to a checkbox
I have a code
Dim i As Intege r = Range("AR5000").End(xlUp).Ro For i = 2 To ComboBox3.AddItem CStr(Sheet1.Range("AR" + CStr(i)).Value Nex whenever I run, it gives runtime error 70: Permission denied I want to add the entries in column AR to the dropdown list of the combobox. I cannot use listfillrange as the data will be lost when entries in AR change . AR stores the data resulting from a query TI Shilps |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding item in listbox | Excel Worksheet Functions | |||
| Adding item in listbox | Excel Worksheet Functions | |||
| adding a checkbox | Excel Discussion (Misc queries) | |||
| adding a,b,c,etc to end of item in call | Excel Discussion (Misc queries) | |||
| Adding a Checkbox in Cells | Excel Discussion (Misc queries) | |||
Threaded Mode
