Display/Hide textboxes with combobox and VBA

Hi,

In the Useform I have a ComboBox with drop down options "1 to 12". When you select a number a NameBox and CompanyBox become visible. The number of NameBox and CompanyBox become visible depend on the number selected int he ComboBox. How can I shorten this code:

Please Login or Register  to view this content.

Hi David,

Thanks for your reply,

However that didnt work, various NameBoxs and CompanyBoxs appear as you choose different number from dropbox.

Hi David,

The correction worked but i would like to show this:

When 3 is selected i see:

NameBox CompanyBox
NameBox CompanyBox
NameBox CompanyBox

Right now when i select 3, only third line is displayed