View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
carlo carlo is offline
external usenet poster
 
Posts: 367
Default 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 -