caption

Hello I need help how to send the caption of checkbox or option button to a database in Excel. These controls are sitting on a userform. Thanks

Hi Everyone! I have an import macro that I would like some help with, please. I would like to retain the formatting of the cell(s) and text(s) from my old workbook into the new workbook I am importing into. Is there a way to do this? The code I am working with is: Sub Import() ' Turn...

Afternoon all, Is it possible to change the back ground colour on the multipages ? no default option appears ? also The caption you add to the pages, can that caption be formatted, as I wanted it to appear font size 12 and in bold ? Thanks Pauljj

Hello, I have a large word document which contains tables and "captions" associated with those tables. The tables are updated annually, so i need to link them and excel document which i can update annually or if a mistake is found etc. What i am currently thinking, since each of my tables has...

I'm fairly new to VBA and have created a checkbox userform and want the caption for each checkbox to be the text in a cell in the worksheet. I keep seeing this line of code and copied it directly into the Userform_Click routine and it won't work. Any help with what I'm doing worng? Private Sub...

Hello All, I wanna know if it's possible to asign a caption to my message box other than the yes and no or the ok and cancel stuffs. If this is possible then somebody show me how to do it. Thanks Kelly Sub PrintMaster() Dim answer As Long answer = MsgBox("Are you sure about...

Hello... Can someone please help. I have a frame within a user form that contains 6 checkboxes. The user may select more than one checkbox. I am trying to send the caption of the selected checkbox(es) to the body of an email. I wrote the code below but it returned the same one twice (see the...

Hi I have set up 20+ user forms with approximately 50 controls in each one. When designing the forms, it seemed inefficient to give a unique meaningful name to each and every control, so they are currently named randomnly, i.e CheckBox1 could be beside CheckBox101 but still related to the...

Hello, I have a userform with a multipage control on it. This Multipage has two pages (Page1 & Page2). How to bold the caption of Page1 when Page1 is activated, and formatting regular the caption of Page2 since Page1 is actived? Thank you

I would like to add other language (non-English like Chinese/Japanese) to the caption of Command button and they show up as ?? (no of ? corresponds to number of original character). The working around is using VBA to refer a cell address which contains the non-English characters/words and it...

Symbols ▼ , ▲ are normally displayed in my previous Excel 2010. However, when I update to Excel 2013, the captions on the command buttons simply display chaotic characters. Is it possible to have it displayed properly in Excel 2013? I am using ActiveX command buttons. The "Property Window"...

Dear MrExcel, I have a questionnaire which includes some descriptive data like age range(for example less than 30 years) of respondents which I place them(I mean less than 30 years in persian) in Caption properties of option buttons.I need the numbers in "caption" to appear in persian. I...

Private Sub CheckBox40_Click() Sheets("CheckBox40.Caption").Visible = CheckBox40.Value End Sub I am using a macro to name the sheets the same as the captions, so they will have the same name. I just want it to make the sheet it shares a name with visible, but this errors out on me. I'm...

Hi I am currently building an Excel VBA reporting project . One requirement is for there to be a Pivot Table, which can be built dynamically/change it's fields depending on the source data. It's all going well so far, but I have a problem as follows: My Pivot table variables are as follows...

Hi Am i missing something The label names are comp1label, comp2label, etc The msgbox gives the correct name but applying the caption does not? thanks for you help Private Sub refreshbutton1_Click() Dim i As Integer Dim qL As String For i = 1 To 9 qL = "comp" & (i) & "label" MsgBox qL With...

So I'm new to coding and I was just wondering... Basically, I''ve created a code (for pivot tables) that auto refreshes and inputs the new field into the Values table relative to a cell that has a value (201428). ActiveSheet.PivotTables("PivotTable1").AddDataField ActiveSheet.PivotTables( _...

I use the following script on my home computer to remove captions, however I can not use it on my work computer which is excel 2010 64bit. I found info on changing the script to prtsafe so I made all the adjustments but it still would not work, it kept getting stuck on the hwnd section even with...

I think my previous post was too long and confusing... I can not seem get the below code in red to work. I am trying to change commandbuttons (R1C1, R1C2, R1C3, R1C4 etc) to change their captions to text that is already saved into an array without making a hundreds of lines of code. Dim...

I have a UserForm with a label and a for next-loop and a command button. How can I update the label caption in my for next-loop? When I try updating with lblPercentage = i & "%" it does not update until the for next-loop is ended.

Elsewhere I have created captions for files I load. Normally I would use the command Windows("myfile").activate but the captioned name is what I need to do: CurrentWorkBook = ActiveWindow.Caption Windows(CurrentWorkBook).Activate But I don't know how to navigate to the current book without...