D
David Coleman
Hi Guys
I've hit a bit of a problem and am hoping that you can help...
I've got a series of textboxes on a userform that I need to dynamically link
to various cells on the activesheet. Normally, this isn't an issue as
stagedetails.TextBox2.ControlSource = "D" & workingrow works
happily
However, what I need to do is specifiy both the column and row by variables,
using integers for both options. Again, I could normally use the Cells(x,y)
syntax but
stagedetails.TextBox2.ControlSource = ActiveSheet.Cells(workingrow, x + 2)
gives a "Runtime error '380': Could not set the ControlSource Property.
Invalid property value."
Now I know I could hack a routine together to convert integers to column
letters but it all seems a tad excessive - any ideas?
Many thanks
David
I've hit a bit of a problem and am hoping that you can help...
I've got a series of textboxes on a userform that I need to dynamically link
to various cells on the activesheet. Normally, this isn't an issue as
stagedetails.TextBox2.ControlSource = "D" & workingrow works
happily
However, what I need to do is specifiy both the column and row by variables,
using integers for both options. Again, I could normally use the Cells(x,y)
syntax but
stagedetails.TextBox2.ControlSource = ActiveSheet.Cells(workingrow, x + 2)
gives a "Runtime error '380': Could not set the ControlSource Property.
Invalid property value."
Now I know I could hack a routine together to convert integers to column
letters but it all seems a tad excessive - any ideas?
Many thanks
David