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


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

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

After click

Here are the properties of the buttons:

Is it possible to avoid this scenario?

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

Click Option Button To Make Cells Bold

Mar 25, 2007

Public Sub OptionButton1_click()
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

Auto Update Or Resync Values In Data Validated Lists

Feb 8, 2010

I was wondering if there was some way to auto update or resync values in data validated lists which are dependant on information in other cells.

I attach my spreadsheet. My list in Cell F32 changes depending on what has been selected in cell F31. However, my problem is that, until you select cell F32, it still keeps the previous value on display, if you know what I mean. So! What I would like to happen, is when I select a different option in cell F31, then I would like cell F32 to update and show the first available option from the new list?

View 10 Replies View Related

Spreadsheet That Allows Users To Select Items From A Validated Data List

Mar 25, 2009

I am making a spreadsheet that allows users to select items from a validated data list. Each item in the list has a numeric value in an adjacent column. When the user is entering data they will select from a drop down of the data list in column "A" and I would like to have the numeric value that corresponds with their selection to then autofill in column "B". I have tried VLOOKUP and IF formulas but cannot seem to get anything to work.

View 9 Replies View Related

Macro Enabled Column Hiding Based On Data Validated Dropdown

Mar 26, 2014

I'm trying to write macro for hiding columns based on a drop down answer. The drop down would be in cell B7 on Sheet 1. The colums affected would be in each worksheet in the workbook. The data validation would have a drop down selection choice of 1 through 16. The columns affected range would be H through W. For example, in the drop down if 1 was selected, only column H would show. If two, H and I would show...etc. This macro should affect all worksheets in the workbook EXCEPT sheet 1.

View 2 Replies View Related

Wrong Entry Into Data Validated Cell Triggers Debug On Change Event

Dec 14, 2011

I have a Change Event macro that works properly. I also have several cells that contain a drop down list. If a user tries to enter an incorrect entry...the debug is triggered on my even change macro.

Here's the piece of the Change macro that has issues. Specifically, the .undo line highlights.

With Application
.ScreenUpdating = False
.EnableEvents = False

Set SelectedCell = ActiveCell
myTitle = Cells(Range("Titles").Row, Target.Column).Value
myRow = Target.Row
.Undo: myBefore = Target.Value
.Undo: myAfter = Target.Value

View 3 Replies View Related

Toggle Cell Format: Assign A Key To Toggle Between Two Different Cell Formats

Oct 3, 2007

Is there any way you can use VBA to assign a key to toggle between two different cell formats? I want to toggle a cell from white border with black text to black border with white text and visa versa, with the same key or button. I've searched the posts but can't find this mentioned.

View 6 Replies View Related

Adding Value Only If Cell Is Validated In Row?

Apr 5, 2014

Here is the Scenario what I am into.

Row 1 Col1 Col2 Col3 Col4 Col5 Col6 Total
Row 2 10 "A" 19 "A" 13 "A" 42
Row 3 1 "A" 9 "B" 10 "A" 11

I was trying to have a formula which would add all values in the total column of that row whose adjacent cell has "A" in it . I am not sure if I am clear enough in my explanation but my example above is more clear want I meant .

I tried posting the same post earlier but I guess I was able to explain the same . I was trying to put the formula which will give the total column with a value in which it all gives addition of those values who's adjacent cell as "A" in it in the row .



View 1 Replies View Related

Excel 2013 :: CF With 2 Option Buttons / Multiple Option Groups?

Sep 6, 2013

I have several option groups (Y & N in each) linked to cells to display TRUE / FALSE depending on which option is selected in each group. I have another cell which I want to apply conditional formatting to if EITHER Y or N is selected in all groups. At present I use COUNTIF to check for FALSE=0 in the linked cells which works if all the answers are Y. How do I apply CF if there is a mixture of Y & N (TRUE / FALSE) in all groups (I'm not sure if I've explained that well or not).

Excel 2013

View 1 Replies View Related

Automatic Date: From A Validated List

Mar 10, 2009

In Column G I have a Drop down list of dates. In Column H I want to show the month for the dates, as per when they are selected. I tried simple doing in cell H2 "=G2" they changing the format of the cell for just the month. which worked but for the cells in H that haven't had a dates selected yet it brings back January-00 all the way down. I need a way of getting rid of the January-00 but having the cells ready so that wen the date in G is selected the month auto appears in H.

View 2 Replies View Related

Run Macro On Selection Of Validated Cell

Mar 27, 2007

I have a macro that I am running "onentry" of a worksheet. The problem is that I have some cells that are validated to allow a list. If I manually type a word from the list in the validated cell the macro runs. However, if I make a selection from the list the macro does not run. I guess vba does not see my selection as an entry.

View 9 Replies View Related

Quote Worksheet With Validated List

Feb 20, 2008

i want to create a quote worksheet with a type of material validated list, a type of stock validated list, a volume of material sum, a cost per lb of material varible and a typ of stock % markup to quote stock material. i have a pdf of what i want it to look like i just need help formulating it. thanks. Auto Merged Post;here is a link to the pdf. i am not sure what to call what i want to do...
[url] Auto Merged Post;here is the xls file.

View 8 Replies View Related

Vlookup Changed Validated Cell Value In Macro

Jul 2, 2009

I have a worksheet containing a cell (say A1) that has a validated list of times (data/validation/list) where the cells in the list contain times in 8 minute increments. The user can select cell A1 and manually select any of the validated times from the list. A vlookup formula on this worksheet uses the content of cell A1 to look for this time in another section of the worksheet. When the time is selected manually, the vlookup formula works properly.

As part of a macro, the macro will change the time in cell A1. I do this in the macro by selecting and copying the desired time from the validation list and pasting it into A1. Cell A1 does change to the new value, however the vlookup formula that uses A1 shows a result of #N/A. If I manually change the time, it again works. I am looking for a way to have the macro change this cell to another time and for the vlookup formula to work as it should.

View 2 Replies View Related

Validated Dropdown Lists In Merged Cells?

May 14, 2012

Do not use validated drop down lists in merged cells.

It will only be a matter of time before it breaks Excel.

(Both 2007 & 2010)

View 1 Replies View Related

Auto-fill Cells After Selecting A Validated Date

Apr 4, 2014

I need a formula that allows me to autofill a cell with "X" kind of data after I choose a validated data of Cell A1;

View 6 Replies View Related

Excel 2010 :: Click On Pivot Chart Data Point And Display Data

Apr 22, 2014

Pivot Chart. I would like to set up something to where a user can click on an individual value on a pivot chart (currently a line chart set up with 4 data series) and somehow display some underlying data. I have a lot of information stored in a data worksheet that I can't display all at once, but if a user sees a questionable data point, he/she can click and learn more about it from source data, or even a new query of the data worksheet.

I am using Excel 2010

View 2 Replies View Related

Data Option Locked From Ribbon - How To Unlock

Jun 14, 2013

I was sent a file via email and when I opened it the data option on the top on the ribbon was locked and I need to ungroup rows.

View 2 Replies View Related

Using Option Button To Display Dynamic Data?

Dec 4, 2012

I am currently using 2 options button (radio button) to display different sets of data interactively. 1st option to show data for Male, 2nd option to show data for Female. No problem for both as I am using "choose" =CHOOSE($M$6,J56,J49) formula to display them on row 11th to 17th. But if I were to add in 3rd option called "Both", how do I need to do so? I am expecting the display to go beyond row 18th to show both Male and Female data. There is a chart too that links to these row 11th - 17th currently.

View 1 Replies View Related

Add Option Unavailable When Selecting Data For Chart

Jul 22, 2013

I have a termination report in which i would like to display data via a graph. However, when I right click to select the data it wont let me add the fields that I want to use.

View 1 Replies View Related

Data Valadtion Option On A Range Of Cells

Feb 7, 2007

I am using the data validation option on a range of cells.

On the 'Error Alert' tab I am checking the box for 'Show error alert after invalid data is entered', selecting the 'Stop' style of warning (which should completely prevent entry of invalid data), but the cells with the data validation still allow entry of invalid data. No warning is given either that the data is invalid.

View 9 Replies View Related

Macro To Right Click A Cell And Select Item From Right Click Menu?

Feb 7, 2014

I wonder if it is possible to make a macro that right clicks a cell and then chooses a option from the list?

View 11 Replies View Related

Changing Default Option For Data Series So X & Y Axis

Oct 12, 2007

I'm trying to change the default option for the data series when graphing in Excel 2003 .... I am trying to create a line graph

Excel, by default, is putting static pressure on the x axis and the air flow on the y axis .... I need it to be the other way around

I have found out that:
By default, Excel plots whatever you have fewer of—rows or columns—as the data series

apparently it is possible to change this Excel default option, but I can't figure that out

in step 2 of the Chart Wizard, I have tried many different things, but can't get Excel to chart the Air Flow CFM on the x axis, and have static pressure values on the y axis

View 9 Replies View Related

Data Validation - Option Set Based On Prior Dropdown Without Names Or VBA

Dec 13, 2012

I'm creating a form with drop downs, and I'd like the answer choice someone makes for one question (ie- what county they're in) to affect the answer choices for a secondary question (ie- what city they're in).

I'd like to avoid using names, at least for the second dropdown (since there would be too many names, and in some of the questions in the data set things change too much for names to be a good option). I would also like to avoid using VBA to keep it simple and maintainable. Here is a simplified version of a small subset of the data.

Drop Down 1:
County (options: Santa Clara County, Napa County)
Drop Down 2:
Cities/Towns (options: the cities/towns that relate to the above county selection, without using names)


Santa Clara County
San Jose

[Code] ........

View 2 Replies View Related

Macro To Find And Fill Data With Multiple Search Option?

Jan 18, 2014

I am using the following code to find a NAME in my work sheet and to enter their status. But this macro is not compatible if a duplicate or Similar name exist.What I need is I need this macro to activate the search NAME Cell and then a VB box with OK & NEXT button has to appear. if the activated NAME is exactly the one I am searching, then I will click the OK button then it should display the "Enter Employee Status" box and as continue in my code, But If I press NEXT, the macro should search the next similar NAME and activate it, This process should continue until I click the OK button. (Same like CTRL+F function with an additional Status entry button)

Sub Button1848_Click()
Application.ScreenUpdating =False
Dim BeginCol AsLong


View 4 Replies View Related

Mouse Scroll WITHIN A Data Validation List & Option Macro Assistance

Jan 7, 2010

I'm trying to do a few things actually. I am somewhat a newb at programming, although I do understand how C++ and the coding works within Excel. To me, it's like the English language...knowing all of the vocabulary and formatting it right is important. If I don't know the vocabulary, I don't know what options I have.

This tool is being used in the call center I work in. It is to help eliminate repititious information used to notate accounts. I have attached a picture of what the tool looks like so you can have a better idea of what I'm working with. Here are a list of things I'm trying to do which I have searched and not found answers to:

1. I am trying to use a middle mouse scroll to scroll through validation list. This list information is located on a different locked tab. Basically, I have a few rows where a drop down selection can be made and it would be easier to scroll rather than manually moving the slider within the validation list.

2. As you can see, this "tool" an employee and I have created has many buttons. What I would like to do is to be able to click a button on the right and have it "stack" text within a single cell. In other words, if I click the button once, the text may be entered into the "actions taken" cell. If I click another button, I can have the option (or maybe a little "+" next to the button) to add this button's information to the end of the information already entered within the "actions taken" box. I've tried recording and using the keyboard and selecting "end" and then having the text added, but it didn't work. I've seen "loop" VBA code, but I don't want something to repeat, I want it to stack in the cell when clicked manually.

I'm sure there is a way to make the tool much better using VBA code and not use Excel, but I don't have an extensive knowledge of Excel to do something like that. I'm a very fast learner and understand how the coding works, so if you have an idea which may help, and you understand what I'm trying to do here, please provide your .02.

Basically, it's used so the Customer's name and phone number are entered manually, and then just about everything else is automated by the use of the buttons on the right. If I could get the 2 above options to work, it'd be perfect. I just figured out I could eliminate screen flicker and hide the macros working by using:

View 12 Replies View Related

Input Data Into Option Buttons, Listbox, Text Box Etc In A Frame In Web Pages

Mar 25, 2007

How can data be input through option buttons, textbox, listbox, combos, checkbox in web pages organised in frames?

View 3 Replies View Related

Copyrights 2005-15, All rights reserved