creating a userform

[Charlie]

I want my userform to have labels that are updated with data from a sheet.
Where do I put my code to change things on my form. For example, if I want
to make a checkbox.visible to be false if sheet1.a1="yes" where do I put code
for this.
If I want a page on a multi-page to be visible depanding on a sheet
reference, where does this code go?
thanks.

 

[carlo]

Each form has the load function which loads the form, but doesn't show
it yet. then you can arrange your stuff and make it visible with
form.visible.

load form
checkbox.visible = sheet1.range("A1").value
form.show

you can put this code on a button or anything else.

make the values of sheet1 as TRUE or FALSE, that way you can use the
value directly, without evaluating it first.

hth Carlo

 

[john]

If you unfamiliar with creating userforms have a look at this site
http://www.contextures.com/xlUserForm01.htmlhttp://www.contextures.com/xlUserForm01.html

 

[Charlie]

This was VERY helpful! Thanks. How do I do this: I have a multipage, and
each page is to show data from a sheet that is set up as a database. It will
have 2 to 10 entrys (rows of data) with this data being shown, one entry on
each sheet. Can I programatically add pages to this multipage as the form
loads? If I have the first page set up with text boxes, list boxes, etc to
show my data, can I create more pages on this multipage, if there are more
entries (up to 10)?

 

[carlo]

If you know, that there are maximum 10 rows, i would make 10pages and
hide/unhide them.

hth

Carlo