ExcelBanter - activate cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - activate cell (https://www.excelbanter.com/excel-worksheet-functions/219209-activate-cell.html)

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

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