Post the code. Please remember to wrap code as per forum rules below
VBA Noob
Post the code. Please remember to wrap code as per forum rules below
VBA Noob
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Thanks for the reply.
Here is the code:
![]()
Sub bandwidth_on() Range("F7").Select ActiveCell.FormulaR1C1 = Range("F7") + "205" ActiveSheet.Shapes("bandwidth_toggle").Select ActiveSheet.Shapes("bandwidth_toggle").TextFrame.Characters.Text = "Toggle Off" Selection.OnAction = "bandwidth_off" End Sub Sub bandwidth_off() Range("F7").Select ActiveCell.FormulaR1C1 = Range("F7") - "205" ActiveSheet.Shapes("bandwidth_toggle").Select ActiveSheet.Shapes("bandwidth_toggle").TextFrame.Characters.Text = "Toggle On" Selection.OnAction = "bandwidth_on" End Sub
Removing this line won't select the shape
HTH![]()
ActiveSheet.Shapes("bandwidth_toggle").Select
VBA Noob
Thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks