Disable Checkbox In VBA

Oct 6, 2009

I have a sheet with a number of checkboxes, and I need to conditionally enable/disable some of them.

For example, if the user checks Box1, then the question for Box2 becomes relevant and Box2 becomes available. If Box1 is unchecked, Box2 needs to be unchecked and disabled.

ADVERTISEMENT

VBA - Disable Form Checkbox In Worksheet

Jan 18, 2013

I want to have a Checkbox (Form) that is in my Worksheet to disable/gray-out once it is selected. I don't want people to be able to uncheck it again. I want them to be forced to click another Checkbox to enable it again.

Example:

Two Checkboxes:

Check Box 1 = "Apply"
Check Box 2 = "Delete"

Once "Apply" is checked, gray it out. This will force a user to click "Delete" in order for the "Apply" button to be enabled again. I do not want a user to click "Apply" once selected as their way of 'deleting' the information.

View 1 Replies View Related

Enable / Disable Checkbox With VBA If Statement?

Dec 27, 2013

I have 3 checkboxes on a worksheet. I have a command button to copy/paste data that is captured from a device.

I want the data to go to the ranges that are selected by referring to the true/false driving mechanism of the check boxes.

Obviously if more than one button is checked at one time, the whole shooting match will blow up.

So....how can I allow only one check box to be active at any given time? I'm thinking perhaps a select case statement that refers to the possible conditions of true true true, true true false, true false true, etc....If that would work, how could the code be simplified?

Let's call them cb1, cb2 & cb3. Is this even possible??

View 5 Replies View Related

Checkbox To Enable/Disable TxtBox1

Feb 12, 2009

how to make txtBox1 only useable when optButton1 has been selected only.

I have 4 Textboxes
txtBox1
txtBox2
txtBox3
txtBox4

The following Option buttons are within a Frame called fraFrame1
optButton1
optButton2
optButton3
optButton4

View 9 Replies View Related

Disable & Enable ListBox Via CheckBox

Jun 21, 2008

I have a checkbox (checkbox1) on a userform that functions to disable two listboxes (monthListbox & yearListbox) when checked. For this, I have the following

Private Sub CheckBox1_Click()
MonthListBox.Enabled = Not CheckBox1
MonthListBox.BackColor = &H8000000B
MonthListBox.Locked = True
YearListBox.Enabled = Not CheckBox1
YearListBox.BackColor = &H8000000B
YearListBox.Locked = True

End Sub

This works fine and dandy. However, when testing the userform, when I "unchecked" the checkbox, it did not undo the actions. So my question is, is there a sub to undo the actions that the above code does after I "uncheck" the checkbox. Additionally...under what event would I write this sub since I've already completed the sub for Checkbox_Click()

View 3 Replies View Related

Enable/Disable A Range Based Upon A CheckBox

Oct 23, 2008

I am attempting to modify a spreadsheet so that it will enable a range on Sheet3 (I9:K42) if a check box is checked on Sheet2. If it is not checked, it will lock that range on Sheet 3 and grey (or gray, if you prefer) out that range.

View 9 Replies View Related

Checkbox : Married, Widows, Single Checkbox Is Selected

Feb 25, 2009

married, widows, single checkbox is selected

macro solution
good work.

View 5 Replies View Related

Stop Checkbox Sub From Jumping To Other Checkbox Subs

Apr 16, 2014

I have 3 checkboxes; when one is checked, a set/range of rows should be visible. Only 1 checkbox should be checked at a time.

If checkbox 18 is already checked, and checkbox 20 is then checked, I want the first checkbox unchecked and the rows for checkbox hidden.

I'm using the following code. It works great as long as I check and uncheck the same box before attempting to check another box. But if Checkbox18 is already checked with its rows showing, and I then check checkbox20, the checkbox20 sub runs and as I step through, it jumps to sub checkbox18.

How can I stop my subs from jumping from one to another?

Code:
Private Sub CheckBox18_Click()
If CheckBox18.Value = True Then
Worksheets("TRF").Rows("36:41").Hidden = False
Worksheets("TRF").Rows("42:64").Hidden = True
Worksheets("TRF").Rows("65:76").Hidden = True
CheckBox19.Value = False

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

View 9 Replies View Related

Hide/Unhide Checkbox Using Another Checkbox

Dec 14, 2008

How can i hide and unhide one checkbox using another one? Can it be done using IF formula?
And also i am using this checkbox to function something else as TRUE/FALSE.

View 6 Replies View Related

Checkbox Vba: The Amount From The Subtotal Cell Will Auto Go To The Cell Next To The Checkbox

May 9, 2006

I have been using different keywords to find what I need. I have 3 checkboxes: cash, amex, other. I have a subtotal cell. When the appropriate checkbox is checked, the amount from the subtotal cell will auto go to the cell next to the checkbox. Is this VB?

View 6 Replies View Related

How To Disable #N/A

Jul 23, 2007

I have this following codes on cell G6

=VLOOKUP(G5,'P1'!K133:L135,2)

i want it to show an empty cell instead of #N/A if it returns 0 value...

View 9 Replies View Related

Disable Save As PDF Or XPS

Apr 16, 2013

Is there a way to disable 'Save as PDF or XPS' with the macro? I have tried disabling 'Save as' with the below VBA code but it does not disable 'Save as PDF or XPS'.

VB:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI Then
MsgBox "Save As is disabled", vbInformation
Cancel = True
End If
End Sub

Also I have a macro which saves the excel report in a PDF format with 'Save as PDF or XPS' utility. I would like to enable 'Save as PDF or XPS' when this macro is started and again disable 'Save as PDF or XPS' when this macro stops.

View 1 Replies View Related

Disable A Button

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

Allow Only One Checkbox To Be Used At A Time

Jul 6, 2013

On the attached Dynamic chart I have attached there are 3 checkboxes to display certain data. My issue is this, if I click the outside checkbox and the ISE checkbox at the same time that is OK, it gives me a comparison of the two data sets in a bar chart. Perfect. If I click just the total checkbox it gives me the total info of the outside and ISE, again perfect.

But, If I click all 3, it doubles all the numbers because total is total and outside + ISE also equals the total.

My Question,
-Is there a way to lock out a checkbox if another is active?
if 1 then no 2 or 3. if 2, 3 is OK but 1 is not. if 3 then 2 is ok but 1 is not?
-If it can't be locked can it do something like; If #1 has a check and you try to enter #2 a red error message could come up saying these two choices together the data will be inaccurate. I'm thinking this might be done in conditional formatting.

If option one is doable and easy, is it also possible to have an error message like in my second idea so people will know why they can't click that second box? This would be my preferred fix but I am open to any other option you may have to accomplish this.

View 4 Replies View Related

Turning On A Checkbox

Apr 13, 2008

I want to turn on (tick) a check box from within a macro.

View 9 Replies View Related

Checkbox Reference...

Mar 11, 2009

Checkbox reference. I am using the following code

View 4 Replies View Related

Disable Row Deletion

Mar 13, 2009

Excel 2003 - VBA - How do you detect when a row has been deleted in VBA? Better yet, how do you detect when a row is about to be deleted? I also would like to know the row number. I do not see an event handler that will inform me of the "Delete" event.

View 2 Replies View Related

Disable Macro Once Run

May 26, 2009

Is it possible to disable macro until next day once clicked to run

View 2 Replies View Related

Select All Checkbox

Oct 28, 2009

I have 20 check/tick boxes on my worksheet (CheckBox1-20), each of the 20 tickboxs has its own linked cell A1-A20 - I wish to have another checkbox (checkbox21) that, when ticked will tick all of them.

Also, if unticked it will untick the 20. I'd like this to be a kind of "onclick" command - so that if I wanted to tick 5 of the 20 on their own, the "master" tick box won't interfere with this. If a command button is easier to code than this is just as good.

I've been looking online on on here for the last 2 hours with no joy, not even getting close.

I am using Form Controls rather than ActiveX controls.

View 6 Replies View Related

Check The Value Of A Checkbox In VBA

Jan 7, 2010

I'm trying to check the value of a checkbox that I created in my workbook, but both of the if statements below say "Object does not support this property or method"

View 6 Replies View Related

Checkbox In RibbonX

Jul 13, 2012

I have a RibbonX checkbox that I have added to my ribbon. I am able to attach code to the OnAction callback and when the user clicks the box, the code executes properly. Now for my issue. How can I change the checkbox from checked to unchecked and vice versa within VBA?

My situation is this:

I store a list of employees with certain elements such as start date, department, title, etc. in a table. One of the fields is Inactive which shows whether they are active or inactive. I may want to see all the employees, or just the active ones. My checkbox will allow the showing of both inactive and active employees. The user may wish to save the default setting for this and so I have created a table that holds a Boolean True or False for whether to show inactive employees or not by default. The checkbox always shows unchecked by default when the workbook loads, and I want to change the textbox's checked state based upon the value in the table.

View 1 Replies View Related

Disable Cut And Drag Only Using VBA?

Jan 5, 2013

I need to disable cut and drag only in a workbook. The idea is to avoid formula reference errors when unlocked cells are cut and pasted or dragged. I can find many macros online but none that do only these two things.

View 2 Replies View Related

Always Disable Zero Values?

May 27, 2013

I am looking for a way that I can ensure that Zero Values are never shown, either when you open a new workbook or open a new window. Preferable, one which I can install for any user who needs this. (such as via Book.XLA I think) but AutoExec is fine as long as it is alwys loaded.

View 1 Replies View Related

How To Disable Read Only

Jul 10, 2013

I've got an excel sheet from a guy at work who decided to lock the entire document down so I can't do anything with it. Virtually all the ribbon options are greyed out, there isn't anything locking it in the code, I've tried checking the save as "read-only" option and it's not there. How I can actually save this is editable? I've looked in windows explorer and it's not read-only in there either. I tried save-as and even tried making it an XLS instead of an XLSM and it still won't let me edit it

View 1 Replies View Related

Disable ClearContents

Nov 30, 2006

I found this great code on this forum to disable copy/paste.

I would like to also disable ClearContents..

I can gather from the code that I just need to add a line similar to
EnableControl 755, False ' pastespecial

but change the # for the clearcontents command. But How can I find that number?

Sub DisableCopyCutAndPaste()
EnableControl 21, False ' cut
EnableControl 19, False ' copy
EnableControl 22, False ' paste
EnableControl 755, False ' pastespecial
Application.OnKey "^c", ""
Application.OnKey "^v", ""
Application.OnKey "+{DEL}", ""
Application.OnKey "+{INSERT}", ""
Application.CellDragAndDrop = False
Application.OnDoubleClick = "Dummy"
CommandBars("ToolBar List").Enabled = False
End Sub

View 9 Replies View Related

Checkbox Event

Dec 10, 2006

I need to have a check box, that when it is checked the user must fill in a cell.

View 9 Replies View Related

Disable Right Click. Can It Be Done?

May 1, 2007

Need code or way of disabling the Right Click feature in Excel? I think you can change it in the computer settings but I only want to disable it for a particular workbook so I am hoping there is a VBA Code that will tell the user "Right Click Not Allowed, Please use Cut and Paste or Ctrl +V and Ctrl +C"

View 9 Replies View Related

Disable Comments

Mar 3, 2008

I am sure this can be done - I found a similar thread but in a different context to what I need.

I have a user of a workbook who insists on putting irritating red cornered comments in cells, rather than using the handy (and rather large) comments field I put in, especially for her.

View 9 Replies View Related

How To Disable The X On A Form

Mar 18, 2008

i know in VB6 i could disable the X in the corner so someone can't X out of my form, and i see that's not an option in VBA.

So how can i stop the form from terminating when the user clicks that? i want them to be forced to use one of my buttons to close out and finish.

i tried adding something simple like Exit Sub to the Userform_Terminate() sub, but nothing. i can make code run when they click that, but i can't stop it from closing. what to do?

also, the form is being called by macro that does alot of other stuff before and after the form, so just opening a new instance of the form won't help unless you can stop my other code from continueing until the form is actually done...

View 9 Replies View Related

Way To Disable Help Feature

May 22, 2009

I just want to know if there is anyway to disable the help feature in Microsoft Excel?

I have to administer some exams.

View 9 Replies View Related

Set Checkbox In The Next File

Aug 25, 2009

Create a macros, which sets any checkbox in the next excel file
fist link
http://narod.ru/disk/12388811000/car_test.xls.html
or another link of the same file
http://rapidshare.com/files/271305333/car_test.xls
I can't find the name of any checkbox.

View 9 Replies View Related

Disable The X Button

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

Use Of Checkbox On Userform

Nov 2, 2009

Can it be made in VBA as follows:

I have made a userform with the initialize routine. On this there are checkboxes which I would like to be selected for a YES.

When the YES (checkbox) is being selected I than would like to see in the active userform an already made and "hidden" textbox to enter a value for confirmation of a quantity to order.

I have been loking for some sort of Private Sub Userform Change() routine, but can not find this type of routines

View 9 Replies View Related

Checkbox At Chart

Dec 8, 2009

i want to create a chart ,the chart have a checkbox beside it.
so i can check which line to display....
example
test1 (group112data,group113data)
test2 (group112data,group113data)

then the chart selection is to select 1 then it will diplay group112 result (test 1 and test2),this is to make comparison

can i do it for normal chart?
or must use pivot chart?

View 9 Replies View Related

Keyboard Disable

Apr 26, 2006

Does anyone know if there is anyway that we can command Excel to avoid accepting aNY KEYBOARD ENTRIES? what intend to do is restrict a certain region on a worksheet for Users not to be able to type anything but but there are commandbuttons on the header which use: Range("C65536").End(xlUp)(2, 1) = "Value for the last cell" code to get the input into the cell. The purpose is to make use of the cmdbuttons with mouse but the data notto be keyed in !!!

View 2 Replies View Related

Disable CMB_Change

Jun 21, 2006

I'm running a module macro which cause a CMB change (and an additional macro run) in one of the sheets.

Since this interrup the main macro run (and also waste unnecessary time) I would like to disable it.

View 9 Replies View Related

Disable Sorting

Jun 23, 2006

I would like to be able to disable a workbook from being able to be sorted, but at the same time allow fitering.

I have tried the following code, but have not got it to work correctly, does any one see what I need to add or remove to get this to work.

Option Explicit

Private Sub Workbook_NewSheet(ByVal Sh As Object)

With Application
. ScreenUpdating = False
.DisplayAlerts = False
ActiveSheet.Sort
MsgBox "You Can't sort sheets in this workbook!"
.DisplayAlerts = True
.ScreenUpdating = True
End With

End Sub

View 3 Replies View Related

Msgbox Disable X

Jan 30, 2007

i have this code to disable X in a MsgBox.......

MsgBox "Closing from X is Disabled", 20, "Action"

Is there another way that the MsgBox shows OK only botton without showing yes/no botton

View 4 Replies View Related

Refer To A Checkbox Value By Vba

May 10, 2007

I have a check box whithin a worksheet. This CheckBox doesn't have any linked cell, and doesn't have any macro asigned. know I would like to refer to the value of the checkbox by vba kind of: ?ActiveSheet.Shapes("CheckBox1").value=true 'from the vba's inmediate window

View 4 Replies View Related

Disable Mouse

Jun 27, 2007

Is it possible prevent the use mouse (disable mouse) while a macro is running? I made a program which starts with animation of Shapes. If you click on shape while macro is running it stops animation.

View 7 Replies View Related

Disable A Macro With Apostrophe?

Nov 6, 2012

,I have the following Macro:

VB:
Private Sub Workbook_Open()Worksheets("Sheet1").ActivateRange("$B$1").SelectSheets("Sheet1").ScrollArea = "A1:z25"End Sub

Now I want to disable the above such that I am able to add an Apostrophe ( ' ) in front of every line of this Macro. Is there a shortcut for this or do I need to Manually add apostrophe in front of every line? And then after disabling if I need to re-enable it is there a shortcut to that too?

View 9 Replies View Related

ADVERTISEMENT