data validation within VBA using range

K

Kaps_mr2

Well-known Member
Joined
Jul 5, 2008
Messages
1,583
Office Version
  1. 365
Platform
  1. Windows
hello,

I am trying to set up data validation using VBA.

However, I get an application defined error on the line in yellow. I want the elements of local_vehicle_range to be the permitted values in the data validation. thanks

kind regards
Kaps
data validation.png
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
You must log in or register to reply here.

Similar threads

K
  • Question
excel vba data validation
Replies
1
Views
98
Kaps_mr2
K
R
  • Question
Working built-in function won't work within User-defined function
Replies
8
Views
97
roscoe
R
N
  • Question
Multiple Conditional Data Validations
2
Replies
13
Views
717
Nathan Asius
N
A
  • Solved
VBA formula
Replies
3
Views
180
Anthony47
A
A
  • Question
Worksheet Change Event Triggering With Cell Validation "Cancel"
Replies
1
Views
226
rlv01
R

Forum statistics

Threads
1,215,119
Messages
6,123,172
Members
449,094
Latest member
bes000

Share this page

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