Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA TextBox problem
I have a problem with creating a textbox with vba macro. The actua
creating isn't a problem but I need to Link a spesific cell as well And that is giving me some hard time. Below is the code that I have recorded and below that is the code have written based on the recording. I would also have define th backcolor of the textbox when it is created. ActiveSheet.OLEObjects.Add(ClassType:="Forms.TextB ox.1", Link:=False Left:=100, Top:=97, Width:=168, Height:=33).Select ActiveSheet.OLEObjects.Add(ClassType:="Forms.TextB ox.1" Link:=Range("G7"), Left:=100, Top:=97, Width:=168, Height:=33).Select It does't give any error messages, but the cell isn't linked to th textbox either. Thank you for your responses -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with TAB key and Textbox controls | Excel Programming | |||
Textbox problem | Excel Programming | |||
Excel VBA - Userform Checkbox/Textbox Problem | Excel Programming | |||
TextBox SetFocus Problem | Excel Programming | |||
Excel textbox problem | Excel Programming |