Hiden Column

[Patrick Simonds]

I am using the code below to populate the TextBoxes of my UserForm. My
problem is, that "TextBox3.Text = rng(1, 4).Text" refers to a hidden column
so nothing appears in the TextBox3. Is there away around this? While I need
the data in column 4, I do not need it to show on the worksheet.

TextBox1.Text = rng(1, 1).Text
TextBox2.Text = rng(1, 2).Text
TextBox3.Text = rng(1, 4).Text

 

[Norman Jones]

Hi Patrick,

I cannot duplicate your problem. I experience no difficulty in populating a
textbox with text from a hidden column.

 

[Patrick Simonds]

Does not work for me. May be some change with Excel 2007. If I unhide the
column the TextBox populates, but not when the column is hiden.

 

[Patrick Simonds]

Found the problem. The cell contained a date had to make the code read as
follows:

TextBox3.Text = rng(1, 4).Value
TextBox3.Text = Format(TextBox3.Text, "mm/dd/yy")