Dynamic form

[angelapercival]

Hi all,

I wondered if the following would be possible....

Can I create a dynamic form within excel? I want a user to be able to select from a number of form options and based on the form option selected certain fields are then populated to capture data?

 

[GS]

Hi all,

I wondered if the following would be possible....

Can I create a dynamic form within excel? I want a user to be able
to select from a number of form options and based on the form option
selected certain fields are then populated to capture data?

Yes, it's possible! Specifics, however, will require lots more info...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[samdthompson]

Hi all,



I wondered if the following would be possible....



Can I create a dynamic form within excel? I want a user to be able to select from a number of form options and based on the form option selected certain fields are then populated to capture data?

Yes. Best way, which can get a bit fiddly if it a huge form, is to assign macro to say a radio button which hides / shows objects within the form. Thus for each radio button in say column 1 of form a set of option buttons in col 2 of the form is visible to users.

 

[angelapercival]

Great stuff, thanks for the help guys.

I'll give the macro's a go and I am sure I will be back in touch in the near future for assistance