Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
activate cell
Hello Everyone - need help
Please suggest a excel formula cell a1 is blank while cell a2 has a pulldown menu containing list of months when i enter a figure in cell a1 I require cell a2 to be active with the pull down menu and should prompt to pick up the month from the ajoing cell Thank you Kind regards varun |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
activate cell
Please suggest a excel formula
One simple way for the alert which might suffice In B2: =IF(ISNUMBER(A1),"< Select month in A2","") Format B2 in bold red font -- Max Singapore http://savefile.com/projects/236895 Downloads:23,000 Files:370 Subscribers:66 xdemechanik --- "varun" wrote: Please suggest a excel formula cell a1 is blank while cell a2 has a pulldown menu containing list of months when i enter a figure in cell a1 I require cell a2 to be active with the pull down menu and should prompt to pick up the month from the ajoing cell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to activate macro from cell | Excel Discussion (Misc queries) | |||
how to activate a cell if it contains data | New Users to Excel | |||
Activate cell at end of range | Setting up and Configuration of Excel | |||
activate a cell value through a macro | Excel Discussion (Misc queries) | |||
Activate Cell | Excel Discussion (Misc queries) |