bradyboyy88
Well-known Member
- Joined
- Feb 25, 2015
- Messages
- 562
Is there any way to do this using the shape object?
Ie,
Sheets(1).Shapes("textbox").method = verticalscroll
If not what is the best way to approach this as I currently have just been using the shapes object for creating a lot of my textboxes.
Just out of curiosity since I google a lot of stuff related to vba , can I use basically anything from vb in my vba coding? For instance I found this link which lets me define a scrollbar property and define a textbox object but could not get it to work. Just wondering if I should only bee looking up solutions specific to vba in excel and not vb in general as it might use .net?
https://msdn.microsoft.com/en-us/library/system.windows.forms.textbox.scrollbars(v=vs.110).aspx
Ie,
Sheets(1).Shapes("textbox").method = verticalscroll
If not what is the best way to approach this as I currently have just been using the shapes object for creating a lot of my textboxes.
Just out of curiosity since I google a lot of stuff related to vba , can I use basically anything from vb in my vba coding? For instance I found this link which lets me define a scrollbar property and define a textbox object but could not get it to work. Just wondering if I should only bee looking up solutions specific to vba in excel and not vb in general as it might use .net?
https://msdn.microsoft.com/en-us/library/system.windows.forms.textbox.scrollbars(v=vs.110).aspx