View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ram[_5_] Ram[_5_] is offline
external usenet poster
 
Posts: 42
Default Command button code

Hi

I am designing a form in which I have given the following :-

Number of modules : options 1 to 5 in dropdown list (Data -
Validation)

now for example a end user selects 2, then there are a set of cells
that get unhidden, so that the end user can fill the module details.
For each of the 2 modules they click on a link to take them to a page
"More Info" for providing more details of the modules. In the "More
info" page i have a command button that says continue. And on clicking
this button I want a msg box to appear asking user to fill module no 2
information and activate "Module_2" cell. If user has filled in all
details then it should take the user to a specific work sheet
(All_Details).

Same to follow for the other number of options (1,3,4 and 5)

Thanks for help !!!