Hiden Column
 

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

Hiden Column
 

Hi Patrick,

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


---
Regards,
Norman



"Patrick Simonds" wrote in message
...
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

Hiden Column
 

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.


"Norman Jones" wrote in message
...
Hi Patrick,

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


---
Regards,
Norman



"Patrick Simonds" wrote in message
...
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

Hiden Column
 

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")

"Patrick Simonds" wrote in message
...
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.


"Norman Jones" wrote in message
...
Hi Patrick,

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


---
Regards,
Norman



"Patrick Simonds" wrote in message
...
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