drop down box

  1. D

    YES/NO with values assigned

    Sorry that my first post should be so obvious, but I've tried searching the forum and can't find exactly what I'm looking for. Here goes: I'm working in Excel 2007 and have a cell with a defined name, that I use elsewhere in a formula. All I want to be able to do is to have a YES/NO drop down...
  2. S

    Drop Down Box - clear if specific option selected

    Hi All, i do hope you can help... I've created a drop down box in a range of cells that contain various options including an "Other - Please Specify". the problem i have is that i would like it for the contents of the cell to be blank if this option is selected so that the user can manually...
  3. T

    exclude options in drop down menu's; insert lines after specific combinations

    Hi guys and girls,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I'm working on a new excel form and have the input ready, now the layout needs some more attention and i'm confused:confused:. I tried to understand the posts on the forum and...
  4. B

    How to Identify the selected text from the dropdown menu of an autofilter using Maros

    I want to identify the text of the selected text from the dropdown menu of an autofilter to utilise it in macros for calculation. How can I identify the text in macros.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> If you have thing it is not...
  5. A

    Drop down applying of conditional format

    Morning all, Got a bit of an odd one, I've had a trawl through the archives and can't find anything quite applicable... What I'm after is a drop down that contains the options:- Live Completed Re-Diarised However, these need to be just the drop down options and independant of the Cell...
  6. J

    Select One - Populate Another?

    I need help finding what formula I need to create this in Access 2007. This database is to show the number of times an employee contacts the help center. Each person staffing the help center documents the employee name, Supervisor, question asked, and the response. I need the...
  7. E

    how to have a drop down box option, once selected then have another cell display a series of data?

    I have a drop down box with a range to select from. Let's say my data range (in the drop down box) is A1:A5 A1: A A2: B A3: C A4: D A5: E If I select A1, I want cell C1 to display what is listed in B1, but if I select A2, I want C1 to display what's listed in B2 and so on. So long as I select...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top