View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Skipping textbox

Hi,

Tabstop = False
You can also protect the text by using the Locked property.

Any reason why you would not use a label?

Cheers
Andy

WLMPilot wrote:
I have a userform that will have certain textboxes automatically equal a
value based on input for a combobox. How do I set those textboxes so that
the user cannot access them, thus bypassing to the next textbox to accept
user input?

Thanks,
Les


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info