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


ADVERTISEMENT

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 View Related

ActiveX Option Buttons VBA

Mar 19, 2014

I am looking for a way to use 2 optionbuttons in vba. The option buttons are in different groups, and are independent.

I cannot get this to work. Is this even possible? In sheet1, the vba would read something like this.

View 9 Replies View Related

VBA Code To Add Option Buttons To ActiveX Frame?

Jun 10, 2014

I want to write a VBA code that will place ActiveX Frame directly onto the worksheet and then add 3 Option Buttons from Toolbox into that frame.

I could not find an answer searching through the web... Also when trying to record macro and see the code it did not record placing the buttons from the toolbox or any formatting (color, caption, etc.) via properties...

When formatting the buttons it would be useful if the selected radio button would have different color, bold font, etc.

View 5 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

ActiveX Click Control--STOPS When On Another Sheet

Nov 23, 2007

RE: Macro ActiveX Click Control--It stops when on another sheet

Macro runs OK when run from menu.

An activeX click button was put on sheet B.

Right click the control, View Code, Paste in code from macro, then click button.

It runs the part of the macro that applies to sheet B, goes to previous sheet A, and then stops. The range select line for the named range on sheet A is highlighted in yellow. It stops when selecting any range or cell on sheet A, like B2.

Any idea why this code does not work on sheet A when ActiveX button is on sheet B? Is there someplace else that the control can go? Using Excel 2000.

See part of code below, which starts on sheet B:

' Macro recorded 11/22/2007

Range("SortAll").Select
Selection.Sort Key1:=Range("T2"), Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
ActiveSheet.Previous.Select
Range("FormBase").Select (STOPS HERE)
Selection.Copy
Range("Formul").Select
ActiveSheet.Paste
ActiveSheet.Next.Select
FormBase is a named dynamic range
FormBase=OFFSET(A!$A$2,0,0,1,MATCH(1E+306,A!$2:$2))

View 9 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

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

ActiveX Command Button Text Looks Bad

Aug 12, 2009

I have created an ActiveX command button and the text on the button looks crude. I know that is not very descriptive but I am unsure how to describe it. The text looks jagged and some letters are missing chunks of their letters. The font I have chosen is Calibri.

If I create a Form Controls button I do not have this problem but I want the button to have a particular background color so I do not believe I can use a Form Controls button.

I do not know why the other Calibri text on the worksheet looks fine while the ActiveX Calibri text does not. The attached image shows the two buttons with the top one being the ActiveX button while the bottom is a Forms button.

View 11 Replies View Related

Reference ActiveX Button Which Has Been Clicked?

Mar 19, 2013

Is there a way in VBA to reference the activeX button which has been clicked? Like a ThisWorkbook equivalent for a button?

I have quite a few button whereby they set a parameter for a procedure 'TrendData' based on the row they sit in. Currently I just have the row number hard coded i.e. Call TrendData(5) but I want to amend this so that when I add a row it doesn't offset all my buttons.

For Example

Call TrendData(CommandButton3.TopLeftCell.Row)

However instead of typing CommandButton3, CommandButton4, etc. I would like the code to know which button had been clicked and just use that?

View 9 Replies View Related

Centering Text On ActiveX Button?

Apr 2, 2014

I have searched high and low and cannot seem to find an answer. I have inserted an ActiveX button in a cell to run 3 macros when pressed. I cannot get the 4-letter name on the button to appear centered on the button, unless I make the button larger than the cell, which I do not want to do.

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

ActiveX Control Button Changes Size For No Reason

Feb 18, 2014

I have created several macros where i use an active-X control button. This button is pressed and the macro begins...........but every now and again this button changes size for no apparent reason.

I have read countless articles/posts about what "may" be causing the problem but i have never read anything which clearly identifies the soln to this problem and the problem has been out there for years. To make matters worse the problem can not be duplicated on any regular frequency that i am aware of............so its not like i can post a file that will show the problem.............

View 4 Replies View Related

ActiveX Toggle Button Changes Cell Color?

Oct 5, 2012

I am creating a status board at work... Kinda like an In/out board.

I created a toggle button and using it as the persons named. I want them to be able to go to the excel sheet on our intranet. Be able to click their name (toggle button) and it change the off cell from red to white and the on cell from white to green. Then they can save the excel sheet and close out for the next person.

edit: I would also need it to go back once they click it when they leave.

I have created the active x button, but so far the only thing I can do is get the 1 cell it effects to say true/false.

View 9 Replies View Related

Disable Command Button (ActiveX) Until Next Day Once Pressed

Aug 26, 2013

I have made an excel workbook detailing team performance that all of my team have access to and that requires updating once a day. The first person to access the workbook each day presses a Command Button that updates the workbook and inserts a time/date stamp. However, other members of the team go into the workbook and update it again the same day which then affects the data being reported.

I know i should probably just sack them for not being able to read the time and date but HR would not like that so is there a way to disable CommandButton1 (ActiveX) so that once it is pressed it is disables until the next day?

View 3 Replies View Related

Hiding ActiveX Button When Hide Columns

Apr 16, 2014

I am putting several buttons into my spread sheet and would prefer to use ActiveX controls rather than form controls. But I also need to hide the buttons from the end user (controls are to update data and will be used by the person who maintains the workbook). When I go to hide the columns, the ActiveX button doesn't hide with it. On the other hand, if I use a Form Control Button instead, it does indeed disappear when I hide the columns. Is there any way to get the ActiveX button to hide when hiding the columns?

View 9 Replies View Related

ActiveX Control Button Not Copying And Pasting?

May 14, 2014

I am using the following code to copy a template to a new worksheet each month:

Code:
Sub CopyTemplateNewMonth()
Application.ScreenUpdating = False
Dim SourceRange As Range, DestRange As Range

[Code]....

Everything copies over except an Activex Control button. I also have form control buttons with macros assigned to them, and they copy & paste just fine. The code assigned to the ActiveX button also copy's & paste's just fine...but the button itself does not.

View 9 Replies View Related

Make Invisible Activex Command Button In Selection

Dec 30, 2009

I designed my spreadsheet incorrect.

Everything works good. But when I selecting tables with listbox, I forgot to notice that there also comboboxes.

I mean, rwgrietveld, I use selecting table to hide 'em, but when I hide 'em comboxes should also disappear (become invisible).

is it possible at all to make invisible activex commandbutton in selection?

View 11 Replies View Related

Can ActiveX Control Button Macro Be Placed In Regular Module

Feb 20, 2014

Can Active-X control button macro be placed in a regular module, or does it always have to reside in the sheet module?
Or is the only way to accomplish this is to have the macro in the regular module being called from the button macro in the sheet module?

I somehow seem to remember a way to move/assign an Active-X ControlButton macro to a regular module, but maybe I'm wrong?

View 1 Replies View Related

Form Or ActiveX Button To Stop / Start Code Temporarily?

May 12, 2014

I would like to know the easiest way to temporarily keep a worksheet code from running while I am editing, then turn it back on when I am done. I was thinking a button with these commands(?)>

Application.ScreenUpdating = False

Application.EnableEvents = True

but I don't know which button to use, or if I would need a button for each.

View 2 Replies View Related

ActiveX Command Button Code To Enter Values From One Range Of Cells Into Another

Jun 15, 2014

well, the clear worked well and now I have another idea for a button for my worksheet;

I want the button to insert values from other cells. so when it is clicked, the values in cells F82-F86 are entered in cells E19 - E23.

View 5 Replies View Related

Conditional Formatting For Multiple ActiveX Controls

Aug 11, 2014

I have a workbook with multiple sheets. I want to add conditional formatting for a cell on 1 worksheet based on if multiple ActiveX controls are checked (checkboxes) on another sheet. I have 10 checkboxes (now LinkedCells named "G1" -> "G10") on worksheet "Data Entry". The formula should be if all 10 boxes are checked on the "Data Entry" worksheet, cell "A1" on the "Milestone" will be gray. Any clues on how to write the formula for this Conditional Format?

View 1 Replies View Related

Excel 2007 :: ActiveX Controls Command Button Opening Worksheet In Same Workbook

Feb 6, 2014

I have a workbook with two worksheets, "Main" and "Control".

Both of them are with hidden tabs (unchecked "show sheet tabs").

On worksheet "Main" I have command button which opens worksheet "Control".

The assigned makro is: Sheets("Control").Select

The problem is: when I open "Control" and close after that the workbook, the next time when I open the workbook "Control" pops-up instead of "Main" even though I do not save it.

1. I need macro on "Main" which will allow me to open "Control".

2. Regardless I "Save" or "Don't Save" "Control" when selected and workbook is closed, to open the workbook always displaying worksheet "Main".

I use Excel 2007 (at home) & 2010 (at office).

View 1 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

Formatting ActiveX Textbox For Phone Numbers And Dates

Aug 28, 2012

I have several text boxes on a 'picture' which is the format for a business review. The text boxes are linked to cells behind the picture which picks up company names, cities etc...

Two of the boxes have a phone# and date

The linked cells are formatted correctly but obviously the text boxes, pick up the 'values' not the formats.

is there any way for the textboxes to show the values with the proper format i.e.,

xxx-xxx-xxxx
mmm yyyy

View 2 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