J
Jack Gillis
Under Excel 2003 and with the help of many here in this NG, I have
designed a User Form to display the contents of some of the cells in a
workbook.
The way I did it was, in general, like this:
txtTextBoxName.Text = Sheets("SheetName").Cells(6, 2).Text and so forth
for each textbox and cell.
It works fine until I insert a column or row in the sheet and the info I
want in the TextBoxName is no longer in 6,2.
Is there anyway I can use relative addressing or something like it to
avoid this problem? I have tried assigning a name to each cell I want
to show in the form but can't make that work.
As you probably can tell, I am in over my head here and will appreciate
any help.
Thank you
designed a User Form to display the contents of some of the cells in a
workbook.
The way I did it was, in general, like this:
txtTextBoxName.Text = Sheets("SheetName").Cells(6, 2).Text and so forth
for each textbox and cell.
It works fine until I insert a column or row in the sheet and the info I
want in the TextBoxName is no longer in 6,2.
Is there anyway I can use relative addressing or something like it to
avoid this problem? I have tried assigning a name to each cell I want
to show in the form but can't make that work.
As you probably can tell, I am in over my head here and will appreciate
any help.
Thank you