| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
populate cells using select case
Hi all,
Another question if anyone can help: If (for example) i put the text Dress in cell A1, can i put the cost of the Dress in cell B2, if i put the text Trousers in cell A1 can i put the cost of the Trousers in cell B2 etc using a select case statement? I know how to to do this using a miltiple "if" function in the worksheet but i am trying to automate this using select case in a macro and can't get it to work. Thanks in advance for any help on this. Taffy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Case not recognized in Select Case | Excel Programming | |||
| Case without Select Case error problem | Excel Discussion (Misc queries) | |||
| End Select without Select Case, Block If without End If errors | Excel Programming | |||
| How do I select cells and make the info populate into a form? | Excel Worksheet Functions | |||
Threaded Mode
