Listbox to select cells

[Caleb Runnels]

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?

 

[Guest]

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