Disable Forms Option Button Once Checked
Apr 15, 2008
After a user has selected the required option buttons, is there a way to disable them without deleting, so that they are still visible (for history tracking) but not modifiable?
'09-- Check metrology info
If Worksheets(" Split Lot Info").MetrologyYes.Value = True Then
Worksheets("Split Lot Info").Shapes("MetrologyYes").Enabled = False
Worksheets("Split Lot Info").Shapes("MetrologyNo").Enabled = False
If Worksheets("Split Lot Info").MetrologyNo.Value = True Then
nResponse = MsgBox("Are metrology steps set up?", vbOKOnly, "Missing information")
Worksheets("Split Lot Info").Shapes("MetrologyYes").Enabled = False
Worksheets("Split Lot Info").Shapes("MetrologyNo").Enabled = False
End
End If
End If
View 3 Replies
ADVERTISEMENT
Jan 26, 2014
I have two option buttons on a user form, one for a temperature of <250 & one for a temperature >250. I want the option button >250 to be greyed out or have it so that you cannot choose it & option button <250 selected if a certain criteria in a list box is selected. The list box is called Valve_Model & the criteria i want it to work on is if the valve model HPBV Soft is selected & HPBV Soft AC.
View 14 Replies
View Related
Dec 6, 2008
I am creating a worksheet that has multiple pricing options. Next to each pricing option is a form control check box. I would like the worksheet to automatically total the checked rows only. I have linked the check boxes to the corresponding cells with pricing. I did not use Active X controls.
View 2 Replies
View Related
Aug 4, 2009
The user form consists of 2 pages. The second page can only be accessed from a control button on the first page (much like the next button on a wizard). I have disabled this button. I have 4 check boxes on the page and want the button to be enabled when any one of these is checked.
I managed to figure out the code for enabling the button any one box is checked:
View 3 Replies
View Related
Dec 8, 2013
I have workbook having 3 sheets out of them 1 sheet name "report". I want vba to disable copy /past option to sheet Report only with msg " copy not allowed" if key clt+c or copy option selected
View 1 Replies
View Related
Jan 25, 2007
I want to be able to disable the save query definition option for a worksheet using VBA. Right now I have to right click a cell and then go to Data Range Properties and then uncheck the save query definition box. If there is a way to automate this that would be great.
View 3 Replies
View Related
May 16, 2014
See attached file illustrating exactly what I'm trying to do.
I won't repeat the exact same things I wrote in the file, but the Summary is that I need to first make such that only certain check boxes can checked at any one time, then make the command button run certain macro(s) depending on which boxes are checked.
View 8 Replies
View Related
Apr 29, 2009
Is there any option to deactivate the "Disable macros"
Or
When i open the userform it asks for enable and diable macros. If i click "Disable macros" then the users can manipulate the data inside the excel sheet. i need to avoid this problem.
So, is there any option that if i do "Disable macro" then the corresponding sheet for the which the Userform is linked should not be visible or hidden.
View 9 Replies
View Related
Apr 9, 2008
Is there a way to remove the option to open a file as read only when the file is already open by another user? Ideally when a user tries to open a file that is already in use they would get a message to that effect and the only option at that point would be for them to select "notify" when file is available.
View 8 Replies
View Related
Mar 20, 2007
to create button that run the form!
i did try but the button did not run the form!
View 4 Replies
View Related
Aug 23, 2009
Can the backround color on a forms toolbar button be changed or must I use a control toolbar button if I want the button in color? I would prefer using the forms button and have tried customizing (tools/customize/forms) then right clicking on the forms button icon and selecting “Edit button image”, clicked on the desired color and clicked ok.
View 2 Replies
View Related
Apr 15, 2007
I must have disabled right click on the forms button. I usually associate a macro with the button but the menu disapeared. How can I get it back.
View 9 Replies
View Related
Aug 30, 2006
code below whould return value "a" to specified range(s) The cells are formatted Marlett, 10pt, black, bold, center. Should return a nice tick mark to the specified range if selected shape has value of 1. I double chk'd the name of the shape referred to in code and it is correct Yet value of "a" is not returned, though the chkBox is "ticked". What else can I check?
Option Explicit
Sub cv_ReviewCheckBoxes()
Dim wbBook As Workbook
Dim wsNotesLoose As Worksheet
Dim wsCoinRolled As Worksheet
Dim wsCoinLoose As Worksheet
Dim wsSummary As Worksheet
With Application
.Calculation = xlCalculationManual
.DisplayAlerts = False
. ScreenUpdating = False
End With.........................
View 3 Replies
View Related
Dec 17, 2009
I'm trying to create a form using radio buttons from the "Forms Tool Bar" and not sure I shouldn't be using the "Control Tool Bar"
I've got multiple buttons and wanted to group them so i used the "Group Box" from the Forms tool bar but now there's a box around the buttons (I've turned off Printing for the box) that gets in the way of other text on sheet. I did some searching and thought I read where you could also use the drawing tool bar and draw a rectangle around the buttons which would then let them operate independent of other groups of buttons but that doesn't seem to work so I'm guessing I imagined it. I also noticed that if you don't draw the "Group Box" around the hole radio button box, they don't work with others in the same "Group Box"
I'm not sure if I should use the buttons in the "Control Tool Bar" but I'm thinking I should so that I have the flexibility should I decide to do something different in the future. I'm thinking about using the buttons to hide a sheet as well as select the sheet for printing, but for now one hurdle at a time.
Lastly I tried looking up some information on how to get the "Control Tool Bar" radio button to behave similar to the "Forms" version of the button (i.e. click the button and it appears to alternate from other buttons in the group), however when I place my mouse over the button it selects it rather than letting me change it's state from true to false.
View 8 Replies
View Related
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
Feb 1, 2010
I have a button on excel form. I need to disable it once user has clicked on it.
I couldnt find name of it on the form anywhere or how to refer it to in the macro.
View 9 Replies
View Related
Oct 22, 2009
I want to disable the X button on the top right hand corner in excel, but still allow the user with the option of closing the workbook via File and then scrolling down to EXIT. (Not close). I have disabled most of the functions in the Menu bar Close being one of them.
So only Exit is now enabled. When I click on the X it give me the following message as shown below advising me to go to the File menu to Exit, this bit I am happy with. However this is were my problem begins, when I go to File and Exit I get the same message as below and can not exit the application.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = True
MsgBox "Please select EXIT from the File Menu.", vbCritical, "Cannot Close"
End Sub
View 9 Replies
View Related
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
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
Jan 2, 2010
I have a worksheet where the user selects between two option controls, which are mutually exclusive. when they toggle an option, a user form pops up, depending on which option they selected, and askes them for a number, which is used in a calculation elsewhere in the page. The user form has a cancel button, in case they decide to back out. If they cancel, I want the option buttons to reset back to their original state.
The problem I'm having is that when I code it, if you select cancel on the user form, it causes the option to revert back to it's previous state, but that triggers the selection of the option again, which pops up the form, making a neverending loop! Is there a better way to do this? I tried it with a toggle button, with the same results.
View 14 Replies
View Related
May 14, 2013
I have user form with 5 OptionButtons in one group called Group1 and another 5 in Group2.
I need that those 5 OB in each group had value from 1 to 5 and then user selects one OB it will inset that value (not TRUE or FALSE) into cell and same with Group2.
Private Sub CommandButton1_Click()
Cells(ActiveCell.Row, "E").Value = Need value of Group1
Cells(ActiveCell.Row, "D").Value = Need value of Group2
End Sub
View 5 Replies
View Related
Sep 18, 2013
I am looking for Multiple IF formula that linked with options button.
If D10=True 16+(C12*2.10)
If D11=True 14+(C12*1.6)
If D12=True 12+(C12*1.3)
If D13=True 10+(C12*1.15)
If D14=True 16+(C12*2.10)
From D10 to D14, there is always one True and others are false.
View 2 Replies
View Related
Nov 7, 2013
Working on a project for a client, and I have two option buttons set up on the spreadsheet, grouped together with a frame and linked to the same cell. Working on the sheet on my computer, the button on the left gives me a value of "1" and the button on the right is "2". When I email the spreadsheet to my client, the buttons reorder themselves, so that the button on the left gives him a value of "2" and the button on the right is "1". Is there a way to prevent this?
View 1 Replies
View Related
Aug 11, 2008
I am trying to make an option button visible only when a cell has a value, I understand that this will have to be done in VBA. So I have a value in C10 on page "Edit" and I only want my option buttons to appear when this cell has a value.
View 9 Replies
View Related
Jan 26, 2007
In ThisWorkbook Userform2 is triggered upon a double click
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
UserForm2.Show
End Sub
Userform2 has Frame1 (Option Buttons 1-6) and Frame2 (Option Buttons 7-12)
Private Sub OptionButton1_Click()
Call ProjectBuildings
Range("A1").Select
End Sub
Private Sub OptionButton10_Click()
Call BondIndustrial
Range("A1").Select
End Sub
The user can click away and things work great. The macros that are triggered search a number of Workbooks and individual Worksheets looking to select either of two (hence the two Frames) specific items.
If the user clicks any Option Button in Frame 1 (works) then any Option Button in Frame 2 (works) then goes back to the same Option Button in Frame 1 (nothing) I have a problem.
How do I clear the first Option Button in Frame 1 after the user selects another Option Button in Frame 2?
View 4 Replies
View Related
Feb 22, 2010
i want to dis able and enable this button using three criteria, and auto paste the comment to other sheet.
View 2 Replies
View Related
Oct 4, 2010
Is there anyway to easily disable/dim the Excel Close (X) Button as I want to force my users to close an Excel workbook via a button?
View 9 Replies
View Related
Mar 29, 2012
how to disable X button in the Userform?
View 2 Replies
View Related
May 22, 2007
When you push the enter button while in a cell it takes you to the next cell down. is there anyway to disable that.. or make it so when someone pushes the enter button it tabs to the right?
View 9 Replies
View Related
Mar 27, 2008
I have a macro associated to clicking a form button.
If possible, if a certian cell value is equal to 0, I want to diable this button. I do not wish for theuser to be able to run the macro associated with that button click.
If found something similar, but in my case, I cannot find the equivalent to CommandButton1, if that's even what I'm using.
If Worksheets("SHEET").Range("A1").Value = "" Then
CommandButton1.Enabled = False
View 9 Replies
View Related
