Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox to select cells
I'm stumped trying to figure out how to have a list box select an individual
cell. I'm needing to select a value from the listbox, click on a button, the macro selects the cell that corresponds with the listbox selection, then opens it up in a textbox to edit it. Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox to select cells
Selecting the cell may not be to difficult, I'm not sure what you want to do
after it has found the cell. However, here is what you may want to do to select the cell. Use the listbox, on the properties dialog box, select the linked cell and type a cell reference that you are not using maybe IV1 or whatever, in there you will have the value selected; then you can assign that cell value to a variable and do a Find on that text, ask it to return the cell address or simply select the cell. Then I got lost on what else you need to do. You may want to elaborate a little more see if I can help you. Michael Arch "Caleb Runnels" wrote: I'm stumped trying to figure out how to have a list box select an individual cell. I'm needing to select a value from the listbox, click on a button, the macro selects the cell that corresponds with the listbox selection, then opens it up in a textbox to edit it. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double click item in Listbox to select item and close Listbox | Excel Programming | |||
MultiColumn ListBox, linked to a range - select cells | Excel Programming | |||
Multi-select listbox help! | Excel Programming | |||
multi select listbox | Excel Programming | |||
Select from table and listbox | Excel Programming |