PDA

View Full Version : Move to different cell based on selection



EricM
03-23-2005, 11:57 AM
If I have a list box in cell a11 how can I get excel to goto a different cell based on the value the user selected in the list box
For example
IF the users selects the value yes then the cursor will goto a13

2 catches to this though. I need to use it for different rows (8 total)
and
I need to force the user to input a value into the goto cell.

Zack Barresse
03-23-2005, 12:25 PM
Hi Eric,

Is there any chance of you uploading a sample file? If not, please describe exactly what kind of listbox you have created. Plus any additional steps that need to be taken.

Also, a brief description of what you are trying to do this for may help in offering some other solutions as well.

Paleo
03-23-2005, 12:33 PM
Eric,

- create a table with the value you want the user to see at the first column and the column you want to send him at the second;

- name this range;

- set this name as the ListFillRange property at the ListBox

- set ColmunsCount equals to 2

- set BoundColumn equals to 2

- set Width equal to ";10"
You may change the 10 to fit your text.

- set the onchange event from the ListBox to run a macro

- put this inside the macro


Sub GoCell(Cel As Range)
Cel.Select
End Sub