I am creating a text box in excel using the following code:
ActiveSheet.OLEObjects.Add(ClassType:="Forms.TextBox.1", Link:=False, _
DisplayAsIcon:=False, Left:=3.75, Top:=722.25, Width:=222, Height:= _
87.75).Select
Question 1:
Stepping through the code gives the "Can't enter break mode at this time"
error. I would ignore it, but I need to step through the code to find out
what is causing my other errors.
Question 2: In the above code, it places the text box in the location I
tell it. (Left=, Top=....) This is referenced from cell A1. Is there a way
for the text box to be placed in a specific cell? (Or be referenced from a
cell other than A1.).
Thanks in advance.
Bookmarks