creating a userform
 

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.

creating a userform
 

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


On Dec 18, 1:34 pm, Charlie wrote:
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.

creating a userform
 

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

--
JB


"Charlie" wrote:

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.

creating a userform
 

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)?

"john" wrote:

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

--
JB


"Charlie" wrote:

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.

creating a userform
 

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

hth

Carlo

On Dec 21, 12:54*pm, Charlie
wrote:
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)?



"john" wrote:
If you unfamiliar with creating userforms have a look at this site:
http://www.contextures.com/xlUserFor...contextures.co...

--
JB

"Charlie" wrote:

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.- Hide quoted text -

- Show quoted text -