Macro that changes data validation drop down box selection

**rexreinke** · 08-11-2020, 09:08 AM

Hi all

first post here, am stuck on a small problem.

I would like to make a simple macro that changes the selection of a drop down box (data validation). I have a list of 'quarter codes' (i.e. 2018-Q2, 2018-Q3) that i can select and this will change the data my spreadsheet outputs. But when I record the macro, it only records me selecting the cell (F1) where the dropdown box is located.

The macro should be assigned to a button that when clicked, changes the selection in the drop down box to the relevant quarter.

If anyone can help that would be very useful.

Thanks

**CK76** · 08-11-2020, 09:22 AM

Data validation is just layer to set cell value.
So, you just need the macro to set cell value to whatever the value you need it to be. No need to control data validation dropdown via code.

Ex:

Please Login or Register  to view this content.

Though it isn't clear to me how you want to change the value of the cell.

**rexreinke** · 08-11-2020, 09:24 AM

Ah yes. That is a lot simpler. Sorry am relatively new to excel so am over-complicating. Thanks a lot.

**CK76** · 08-11-2020, 09:25 AM

Glad to have helped

If you are satisfied with the solution provided. Please mark the thread as solved using thread tools found at top of your initial post.

Macro that changes data validation drop down box selection

LinkBack

Thread Tools

Rate This Thread

Display

Macro that changes data validation drop down box selection

Re: Macro that changes data validation drop down box selection

Re: Macro that changes data validation drop down box selection

Re: Macro that changes data validation drop down box selection

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Data validation drop down with calendar selection

Run a filter/query based on data validation drop down selection.

[SOLVED] Linking data validation drop down selection to open userform

Excel VBA multiple selection drop down data validation list

Macro runs from Data Validation Drop Down List Selection

Data validation drop down list with several selection

Data Validation: Need to restrict drop-down selection

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions