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 -