Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Apologies for the cross post.
Here is a sample of VBA code used to place a value in a cell base on the value entered in the cell previous If LCase(.Value) = "capital" OR _ LCase(.Value) = "grounds" OR _ (etc., for many lines) ..Offset(0, 1).Value = "MP" The code works fine. Now I want to refer to a list on a sheet to determine the value of a cell, i.e., if the value in a cell equals an item from the sheet list, then a value is assigned to another cell. Is this possible? Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pick value off sheet list for VBA code determination | Excel Discussion (Misc queries) | |||
Look up list of values based on single value from pick list | Excel Discussion (Misc queries) | |||
time sheet determination of what day and time rate | Excel Worksheet Functions | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
Pick list on a sheet - multiple rows? | Excel Programming |