caption

Can anyone provide a script that lists the caption names of all work sheet commandbar buttons, one script to list them on a worksheet and another to list them in a listbox. Thanks

Hi, I am trying to program the game "Scattergories" in Excel VBA. I am currently running into problems with checking user-inputted answers to the categories. I have randomized the label captions on the userform to represent the different categories I have stored in an array like the...

I use the following code to remove captions, however if my script opens multiple forms then it only removes the caption from the last opened form, utill I click on the others and then it removes them. Can someone please help with a code to remove each caption when the forms open. My remove...

I use the following script to remove the userform caption, however, sometimes it decides to remove the workbook caption instead, can someone please provide a script that I can use to redraw/ show the workbook caption. 'Option Private Module 'Returns the Window Handle of the Window 'that is...

I got this code from another thread and the code is great EXCEPT, I would like my userform to be modeless. I changed the script to vbmodeless but the form is still locked in modal mode. Any help would be appreciated *** Place this code In a User Form *** Option Explicit Private Sub...

I have the following script to remove captions, can someone please help with a script to show captions. I have tried the following codes by themseleves and together but nothing happens. Application.CommandBars("Worksheet Menu Bar").Enabled = True Application.CommandBars("Worksheet Menu...

I have created a form to enter data into my Excel 2003 worksheet, no problem. But the caption header is showing as a default blue at the moment and I want to change it to my Company's colour scheme (i.e. yellow). Changing "bordercolor" does not change it. I cannot find anyway of changing the...

Hi i'm new here, I have question about put Asian language into Caption of Command Button (active x). The problem is some of alphabet like ớ (in my case it's Vietnamese) will display as ? in Caption. How do i fix that? I have tried some technique but none of them work. Thanks in advance.

In Excel 2003, under XP, I am placing command buttons from the controls toolbox on spreadsheets. The captions are not shown in the default or selected fonts except when the button is clicked at run-time. Then the font returns to its hard-to-read state. I seem to recall finding a solution to...