User Form Doesn't Show When Tab is Added
 

Hello,

I have a user form that you select a product and that product's use
form shows. Now I would like to make the product user form have tw
tabs so that the user could read about the product and see a picture o
the product, if they choose.

The problem is this....when I add the tab to the user form the selec
list box gives an error that the file cannot be found. The debugge
says "object required".

Does anyone know the key to using two-tab user forms? Do I need th
select list box to call it differently?

Thank you in advance

--
Message posted from http://www.ExcelForum.com

User Form Doesn't Show When Tab is Added
 

Hi,

Use a Multi-Page control
multipage.pages(0) is page 1
put your info here
multipage.pages(1) is page 2
put other info here

when the user clicks "Page 1", they see the picture.
"Page 2" they see info.

The tabstrip is basically only for tabs like worksheets.
The page on a stretched tabstrip is the same for any
selected tab.

The object reference probably refers to something you are
using as a reference


eg: for each cell in selection
you have to declare cell as an "object type"

sub Hoo()
Dim Cell
for each cell in selection
if cell.value=1 then
msgbox cell.value
end if
end sub


send the form to me and I will review it.

regards
mark


-----Original Message-----
Hello,

I have a user form that you select a product and that
product's user
form shows. Now I would like to make the product user
form have two
tabs so that the user could read about the product and
see a picture of
the product, if they choose.

The problem is this....when I add the tab to the user
form the select
list box gives an error that the file cannot be found.
The debugger
says "object required".

Does anyone know the key to using two-tab user forms? Do
I need the
select list box to call it differently?

Thank you in advance!


---
Message posted from http://www.ExcelForum.com/

.