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.

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 <Char...@discussions.microsoft.com> 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.

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.

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.

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 <Char...@discussions.microsoft.com>
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. *Itwill
> 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, etcto
> 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, ifI want
> > > to make a checkbox.visible to be false if sheet1.a1="yes" where do Iput 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 -