Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Programattically add scrollbar with linked cell
I am packing to leave for a week today, and I did not bring my flash drive home with the code I’m having trouble with, in it’s entirety, but I recorded this: ActiveSheet.OLEObjects.Add(ClassType:="Forms.ScrollBar.1", Link:=False, _ DisplayAsIcon:=False, Left:=237.75, Top:=137.25...- jdallen
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Programattically add scrollbar with linked cell
I appreciate the response. I already know how to do that, though. I need to put VB code in a module that embeds the scroll bars, then links them. I can create them in VB, no problem. I am having problems referring to them to set the links up. I can do this with a form which is called from a...- jdallen
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Programattically add scrollbar with linked cell
I need to add two scroll bars to each of five new sheets, each with an embedded chart. The scrollbars will move a line on the chart by changing the "X" values, on a different sheet, of one of the lines on the chart. I can add a scrollbar with code, but am so far unable to link it to a cell. I...- jdallen
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
