Click Option Button To Make Cells Bold

Mar 25, 2007


Public Sub OptionButton1_click()
Sheet1.Select
ActiveSheet.OLEObjects("OptionButton1").Interior.Font.Bold = True

End Sub

The problem i have is when i click on one of the option buttons it should change the cells ive highlighted to bold.

View 9 Replies


ADVERTISEMENT

ActiveX Option Button On Click Formatting?

Feb 26, 2013

I'm running into an issue with my ActiveX Option Buttons where they change appearance on click, rendering my transparent settings moot.

Here is an example of the process flow where a user decides to select 'New Visits' instead of 'All Visits':

Before click
before_zps37d416b4.png

After click
after_zps0e12e3e6.png

Here are the properties of the buttons:
properties_zps84fcff45.png

Is it possible to avoid this scenario?

View 1 Replies View Related

Option Button To Make Visible Multi Pages In Userform

Jul 6, 2013

I have a user form with multipage.

With the use of the option buttons,the page needs to made visible or invisible.

Example: on Page one, i have placed radio buttons as page2,Page3&page4.

By default only page 1 should be visible and when we select radio button page2, page2 should become visible or else it should be invisible,when we select radio button page3, page3 should become visible or else should remain invisible.

View 5 Replies View Related

Macro Seems To Make Entire Text String In Cells Bold

Aug 1, 2014

I have the following code:

[Code] ..........

However, whenever I run the code, if there's even on word that is bold in the cell, then the entire text string in the cell turns bold. How can I stop this from happening? i want to keep the format of the text string the same, only remove and replace the items listed in the code.

View 4 Replies View Related

Make 1 Cell Bold If Another 1 Is Bold

Oct 2, 2007

I am trying to create a macro that if a value in a cell in column A is bold, then the value in the same row in column H is bold, then loop it to run on the rest of the worksheet.

View 9 Replies View Related

Click The Master Button, That Would Click Another Button On A Different Worksheet

Oct 22, 2008

Running into this issue of "transworksheet macros"

I have a master "update" commandbutton on sheet 1. I have two sub "update" buttons on sheet 2 and 3 respectively.

What I would like to do is have the user click the master button, that would "click" the two sub buttons so they run their respective macros on their respective worksheets (within the same worksheet.

I have tried pasting the macro code in the master button, telling it to select the sub worksheet and then run the macro, but the marco runs itself on the master worksheet instead.

View 6 Replies View Related

Cells Are Not Updating Until Click The Save Button

Nov 14, 2009

I have a spreadsheet that has several formulas that update once all the values are inputted however I noticed that if I drag the formulas down the column, the cells does not update until I click the save button.

View 2 Replies View Related

Fill Empty Cells With Click Of Button

Nov 26, 2012

I would like to enter N/A in the empty cells E6:E33 with the click of a button. Not sure how to write the code.

View 5 Replies View Related

How To Make A Button To Clear Certain Cells

May 8, 2013

How do You Make a Button to Clear Certain Cells?I don't know how to make a button that clears a1-a5 and b1-b5. How do you do this?

View 5 Replies View Related

Locked Cells :: Change The Cell Color On The Click Of A Command Button

Mar 1, 2010

i want the user to be able to change the cell color on the click of a command button. the worksheet is protected. when the user click the command button the active cell changes to red and offsets by 1. then the work sheet is locked again.

The two problems I am having is 1. I want the range to begin from row 10, column k to column FD. all cells down

the second problem is the current code allows me to edit locked cell columns A to J ...

View 9 Replies View Related

Possible To Make A Word In Formula Bold?

Jul 2, 2006

I am trying to make a word within a formula bold.

The word doesn't have to be bolded depending on the result. It will either appear or not based on the result of the formula. But obviously, if it appears, it [should] be bolded...

Obviously you can't format text on the formula bar. This is something I've wanted to do in Excel for YEARS!

View 10 Replies View Related

Make A Cell Font Bold

Jul 30, 2009

I have the following code that I am using for a header row of an excel sheet

View 3 Replies View Related

How To Make Certain Text In Comment Bold

May 25, 2009

I need to figure out how to make certain text bold in a comment using vba. I'm making it so it adds a comment that looks like this:

View 7 Replies View Related

Make Text Dependant On Cell - Bold

Feb 18, 2010

i have some code where i need to make the text bold but not sure how to go about it
the formula is

View 3 Replies View Related

How To Make MyItem Bold Inside The Textboxes

Jul 19, 2014

myItem = "Big"

myText.Text = myItem & " houses are " & myItem

Is it possible to make myItem bold inside the textboxes? If so, how?

View 4 Replies View Related

Make Part Of A Cell Bold Using A Formula??

May 29, 2009

I have a formula that combines the the text of various cells.

Is there a way to automatically make part of the cell Bold - so in this case I want the Cell B13 to appear in bold.

See formula below:

View 3 Replies View Related

Click On Color Button And After Button Click It Will Color Entire Row Of Cell?

Jan 23, 2014

what code I can put behind a button so that once I click on that button,

What ever cell i click on, the whole row of that cell will be colored a certain color.

Is this where i would used a target approach?

View 6 Replies View Related

Right Click Option

Jun 7, 2009

I lost my right click option in excel, all I get is a little gray box that does nothing. I know it is something I did today, it has worked perfect before. Has anyone seen this happen, the problem is only in excell 2003.

View 2 Replies View Related

Merging Cols Changes Bold To Non-bold Or Non-bold To Bold

Jun 8, 2008

I am merging columns. Col B has all text in bold. Col C has all text in regular font. When I use ASAP to merge, the merged column comes out all bold. When I use a formula to merge the merged column comes out all regular. What I want is for the merged column to contain the bold text from Col B in bold, and the regular text from Col C in regular.

What I want is...

This is for service plan B: Take all data and transer to new server.

What I am getting is...

This is for service plan B:Take all data and transer to new server.

OR

This is for service plan B:Take all data and transer to new server.

View 9 Replies View Related

Command Button Click Creates New Rows Above Button?

Nov 8, 2012

I currently am using a form button to create new rows.

I need two different kind of buttons. I have a button that does this-

VB:
Sub InsertRow()
'this inserts a row where the button is clicked.
Dim r As Range

[Code]....

However, when I try and create these codes using a Command button (I need it for the color), I get the error

"unable to get the buttons property of the Worksheet class"

P.S one other thing, say the button is in row 3, and Cells A1 and A2 are merged, when you click the button in row 3, it should extend the merge to A3.

View 4 Replies View Related

RMB Click And All Of A Sudden No Option To Insert Comment

May 21, 2014

When i right click in a cell i have all of a sudden lost the option to Insert Comment.

View 6 Replies View Related

How To Remove Delete Option When Right Click On Sheet Tab

Jun 21, 2014

When right clicking on the sheet tab, I need to know if it is possible to remove the "Delete" from being an option. My workbook is structured to where if a single sheet is deleted, it screws up all my formulas. I tried to just password protect the workbook, but doing that removes the "Rename" function, which I still need.

View 9 Replies View Related

Toggle Data Validated Option On / Off Within With Right-click?

Aug 2, 2014

This area of my worksheet, Sheets("ACTIVITY").Range("AM2:AM172"), is currently populated by text values from a dynamic, validated list, 'DEL_2'.

Is there a simple way to effectively 'toggle' (on/off) data validation - maybe with right-click - in this area, so that the user can type what they want if their chosen option can't be found in DEL_2?

View 3 Replies View Related

How Do I Make A Msg Box With Out Any Option

Dec 29, 2009

I made a msg box but i dont want any option to be displayed in it.. it only should display as an info to the user.

View 9 Replies View Related

Delete All Text Which Is Not 'bold' In Cells With 'mingled Bold' Text

Jan 23, 2010

I want to have a function or macro that if cells have mingled bold text, that only the bold text shall remain in the cells, and all the rest of the text must be deleted.

View 4 Replies View Related

Make Check Boxes Behave As Option Buttons

Oct 27, 2009

I have a form with at about 1200 checkboxes and I need to make them behave as radio buttons. What I mean is that just one box can be selected in a group of boxes.

Lets say i want to group all 1200 boxes in 400 groups, with 3 check boxes in every group. I want user to be able to select just one check box in every group.

View 12 Replies View Related

Make Thicker Borders Using Conditional Formatting Option?

Jun 26, 2002

how to make thicker borders using the Conditional Formatting option? The options they give you are all thin borders.

View 7 Replies View Related

Set An Option Button By Name

Oct 8, 2009

In Excel 2003 VBA, what is the syntax for controling an Option Button or Checkbox by name or caption

I have tried the following but has an error, I am sure this is a simple one.

View 4 Replies View Related

Option Button Grouping

Dec 10, 2013

I'm trying to replace a bunch of checkboxes on a sheet with a bunch of Form Control Option Buttons. The problem I'm having is every option button I add seems to be grouped with all of the rest of my option buttons. If I add buttons 1 & 2, I need those 2 grouped together, and when I add 3 & 4, I need those grouped together. Currently it's grouping all 4 buttons together so 1 - 4 are linked, but I need 1 & 2 linked together, and 3 & 4 linked together. I've tried grouping, but it still doesn't function how it ought to.

View 13 Replies View Related

Option Button To Post Value

Mar 18, 2009

Not sure how too do this, here is a simple example of what I want too do. Just using different buttons to post a number.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved