script for a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am making a form in Excel. On first sheet threre is the form and on another
sheet there is a list of values. When the user fills in the form, she/he
should select some value from the drop-down list. The next box in the form
shoud have a value that depends from the selected value in the previous box.
Now I would like to make this an automated function by making a script that
fills in the latter box with a proper value. Has anyone got an idea, how to
make this in Excel?

Anneli
 
Hi Anneli

Are you planning on using a VB Userform for this or are
you using a control on worksheet?

Using a Userform is probably the best option. You can fill
the listboxes based on selections by filling them
dynamically using the controls event procedures.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list - link to another worksheet 4
Problem disabling double click event 1
HELP WITH A FORM IN EXCEL. 3
Excel Concatenate Form Name to Parse for function 1
Excell to Web Form filling macro 0
User Form Text Date Format 3
Addressing HTMLText object in Spreadsheet VBA Script 3
Create a Drop down List on a Form 2

Back
Top