Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba Syntax?
hi! soo.. i would like to know the code for:
-in a for loop, for a particular row, finding a cell. ie. if the for loop is on the 2nd row, return the value in the cell("a2"), if 3rd row, ("A3").. etc -creating a dropdown list in code. ie. this is for when (in my for loop) i find an acceptable 'item', it will be added to a dropdown list. so if A2,3,4 is ok, and a1,a5 are not, the dropdown list will look like : "(Value from A2) (Value from A3) Value from A4)" this is gathered from my for loop, and the process should be triggered when a specific cell is changed can you help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba Syntax?
You asked basically this same question earlier today and got some responses.
Apparently those responses didn't help, so you should follow the advice that Mike H gave you back then... post the code you have so far (even though it doesn't work)... this may help us to see what you are trying to do that maybe isn't coming through in your written description. -- Rick (MVP - Excel) "Derrick" wrote in message ... hi! soo.. i would like to know the code for: -in a for loop, for a particular row, finding a cell. ie. if the for loop is on the 2nd row, return the value in the cell("a2"), if 3rd row, ("A3").. etc -creating a dropdown list in code. ie. this is for when (in my for loop) i find an acceptable 'item', it will be added to a dropdown list. so if A2,3,4 is ok, and a1,a5 are not, the dropdown list will look like : "(Value from A2) (Value from A3) Value from A4)" this is gathered from my for loop, and the process should be triggered when a specific cell is changed can you help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA syntax | Excel Discussion (Misc queries) | |||
SQL syntax | Excel Worksheet Functions | |||
Syntax help for if | Excel Programming | |||
If then syntax | Excel Worksheet Functions | |||
Need help with Syntax | Excel Programming |