LISTBOX help...please!

Kristina

New Member
Joined
Oct 14, 2005
Messages
4
I need help getting started on creating a worksheet. I would like to create a worksheet where the user clicks in a column, say column M, and a list is displayed where a selection can be made between the choices, "clockwise" and "counter clockwise" but only when they click in a cell in column M. Once a section between the two is made the selection is displayed in the cell that was clicked on and the list that was just displyed is not longer visible. Would it be best to use a list box for this application? Any help with code would be super. THANKS!
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
  1. Just go to the cell in column M.
  2. From the menu pick Data | Validation...
  3. Click on the Allow: control and pick List
  4. A "Source" control will become visible. Simply type Clockwise, CounterClockwise into the textbox
  5. You can adjust other aspects like message and whether the user can only pick from this list (or if he can type in a different value) etc. using the rest of the dialog box.
 

Kristina

New Member
Joined
Oct 14, 2005
Messages
4
THANKS!

Perfect- This is exactly what I needed! And very simple too! Thanks a bunch!
 

Kristina

New Member
Joined
Oct 14, 2005
Messages
4
Is there a way to make it possible to select more than one option from a list, for example by holding the ctrl button?
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
AFAIK, not with data validation. With listbox controls, yes, you can change the MultiSelect property to suit your needs, but you're going to need VBA to pull values. You may want to just put a "both" option in your list, if that would get you where you need to be.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,125
Messages
5,599,850
Members
414,342
Latest member
K Darrell Smith

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
Top