User Form Doesn't Show When Tab is Added

N

novicevbaer

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
 
M

Mark

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.
[email protected]
regards
mark
 
Top