Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change UserForm ControlSource with VBA | Excel Discussion (Misc queries) | |||
ControlSource Compatibility VBA - VB6 | Excel Programming | |||
ControlSource problem | Excel Programming | |||
Basic Userform Controlsource question | Excel Programming | |||
Valid ControlSource values | Excel Programming |