MatchRequired property

L

lucausa75

New Member
Joined
Oct 15, 2021
Messages
22
Office Version
  1. 2013
Platform
  1. Windows
Dear all,

I have set the "MatchRequired" property of my Listbox to True in order to specifies whether a value entered in the text portion of a ListBox must match an entry in the existing list.
Everything works fine: indeed If I write something different in the list I get the below message
2022_07_20_17_32_30_Start.png


I would like to know how to set to "SET PARAMETER" the ListBox indicated by the arrow above once I click on "OK" button of the message box

Thanks
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
You must log in or register to reply here.

Similar threads

P
  • Question
Data Validation in a UserForm
Replies
7
Views
433
RoryA
RoryA
N
  • Question
Automating textbox updates in PP using VBA to read excel data
Replies
0
Views
435
noobslayer252
N
G
  • Solved
Format & Protect range of cells using VBA
Replies
7
Views
263
Gajendran Yadhav
G
M
  • Solved
'Weighted' random name picker
Replies
8
Views
943
DanteAmor
DanteAmor
M
  • Question
Error 1004 - Can't Copy as Picture, but only on certain computer
2
Replies
10
Views
298
rlv01
R

Forum statistics

Threads
1,214,653
Messages
6,120,751
Members
448,989
Latest member
mariah3

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