+ Reply to Thread
Results 1 to 11 of 11

problem caption properties for commandbutton on userform

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-08-2021
    Location
    africa
    MS-Off Ver
    2016
    Posts
    410

    problem caption properties for commandbutton on userform

    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.

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,410

    Re: problem caption properties for commandbutton on userform

    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'.

  3. #3
    Forum Contributor
    Join Date
    02-08-2021
    Location
    africa
    MS-Off Ver
    2016
    Posts
    410

    Re: problem caption properties for commandbutton on userform

    Hi
    I can give you file contains userform where contains many commandbuttons , but the question is do you understand my request ?

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,410

    Re: problem caption properties for commandbutton on userform

    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.

  5. #5
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: problem caption properties for commandbutton on userform

    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!!!

  6. #6
    Forum Contributor
    Join Date
    02-08-2021
    Location
    africa
    MS-Off Ver
    2016
    Posts
    410

    Re: problem caption properties for commandbutton on userform

    here is the file
    Attached Files Attached Files

  7. #7
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,410

    Re: problem caption properties for commandbutton on userform

    I agree with @sintek

  8. #8
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,937

    Re: problem caption properties for commandbutton on userform

    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
    Maybe???
    Ben Van Johnson

  9. #9
    Forum Contributor
    Join Date
    02-08-2021
    Location
    africa
    MS-Off Ver
    2016
    Posts
    410

    Re: problem caption properties for commandbutton on userform

    thanks sintek for your suggestion, but I search by vba

  10. #10
    Forum Contributor
    Join Date
    02-08-2021
    Location
    africa
    MS-Off Ver
    2016
    Posts
    410

    Re: problem caption properties for commandbutton on userform

    @protonLeah it works very well
    many thanks

  11. #11
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: problem caption properties for commandbutton on userform

    Maybe???
    And then there's that...well well...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Is it possible to Add shadow to commandbutton caption with VBA
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2022, 02:46 AM
  2. [SOLVED] Display Worksheet Properties (visible/Hidden) on UserForm via Label Caption Dynamically
    By RoroBear in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2021, 12:47 PM
  3. [SOLVED] Get Caption From Userform CommandButton During Click Event Procedure
    By skywriter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2015, 02:53 AM
  4. [SOLVED] CommandButton caption from a different workbook
    By cboud in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-19-2014, 01:29 PM
  5. [SOLVED] CommandButton caption set on open
    By JimDandy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2013, 05:36 PM
  6. Commandbutton caption change
    By peter.thompson in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-22-2005, 02:29 AM
  7. [SOLVED] Caption disappears from CommandButton.
    By Ed in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-19-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1