Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hai guys, here is the thing i need.in my excel i am ahving as follows. there ar 3 cells(all r drop down). 1st cell has values like Hour,Minute, 2nd is havin values(1,2..24) and 3rd is having values 5,10,15,20....60. here if the user select hour from the first cell then he has to select values only from 2nd dropdown cell i. 1,2..24. she should n't select 5,10,15..20 dropdown cell. he has to get som message when he did so. and if he selects Minutes from 1st cell then he has to selec only the 5,10,15..60 dropdown cell but not 1,2,..24 cell. and also how can i do if i am having a group of cells like 2nd and 3r cell. how can i achieve this.i have to use VBScript or is there any functio to do this in Excel.i am using MS Excell 2000. plz help me. thanks & regards, Mahesh -- itsmahesh ----------------------------------------------------------------------- itsmaheshp's Profile: http://www.excelforum.com/member.php...fo&userid=1585 View this thread: http://www.excelforum.com/showthread.php?threadid=27408 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Locking a cell based on a cells content | Excel Discussion (Misc queries) | |||
if condition and locking cells | Excel Discussion (Misc queries) | |||
if condition and locking cells | Excel Worksheet Functions | |||
Locking/Unlocking cells upon condition | Excel Discussion (Misc queries) | |||
Locking other cells based on values in a cell. | Excel Programming |