Hi guys,
it doesn't seem to setting caption from windows properties for command button on userform to bottom or above
it's not existed in windows properties . I have many commandbuttons .
is there any way by vba ?
thanks.
Hi guys,
it doesn't seem to setting caption from windows properties for command button on userform to bottom or above
it's not existed in windows properties . I have many commandbuttons .
is there any way by vba ?
thanks.
see big yellow banner - how to upload your workbook
far easier then to give you a solution as your question is not very clear.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
Hi
I can give you file contains userform where contains many commandbuttons , but the question is do you understand my request ?
upload your workbook, then you will more likely get a suitable solution.
Yes I understand VBA very well, but without your file I have no way of giving you a precise answer.
If you are wanting to have the CommandButton Caption to display at Top or Bottom of control, then ...AFAIK...No...
It can be achieved by inserting images or making use of labels...
Untitled.png
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
here is the file
I agree with @sintek
Maybe???![]()
Private Sub UserForm_Initialize() 'move towards top using line feeds after text: Me.CommandButton1.Caption = "Test 1" & vbCrLf & vbCrLf & "" 'moving towards bottom using linefeeds before text: Me.CommandButton2.Caption = vbCrLf & vbCrLf & "test #2" End Sub
Ben Van Johnson
thanks sintek for your suggestion, but I search by vba![]()
@protonLeah it works very well
many thanks![]()
And then there's that...well well...Maybe???
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks