View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shion Shion is offline
external usenet poster
 
Posts: 1
Default drop down and textbox

I am trying to create a userform, accessed to Sheet1, Sheet2 etc. The format
of each Sheet is the same, where data is to be 10 columns.
However, I want the first column to used from a dropdown on the userform and
the next to columns to be filled into textboxes (where the user cannot change
the output data. From the 4th column to the 10th the user can input amounts
in the even numbered textboxes, with dates automatically appearing in the odd
number textboxes. Is this possible?
I have looked and looked, and only have just stumbled onto this web site.
Please help.