Changing Hight and Width of textbox with vba

[at51178]

I have a form with a button and a textbox I would like to click on the button and have the textbox's height and width adjusted but when I click on the button my textbox disappears.This is the code that I am using.


Me.textbox.width = "1"
me.textbox.height= "1"

I know why it is disappearing because it doesn't understand 1 it should be 1" but how do I write that in vba

 

[Eupher]

The default unit of measure in VBA is twips (you can change it with code). One twip is 1/1440 of an inch. So just change the value you're assigning to 1440 and that should give you 1".

Ken S.

 

[at51178]

Thanks a lot it worked
Learned something new everyday