?
Solved

Error Validation on Two ListBoxes

Posted on 2011-02-26
5
Medium Priority
?
233 Views
Last Modified: 2012-06-22
I have two list boxes in my form, i want to implement the below error conditions over the same,

1) I have one Remove button for both of them, if the user didn't select any item in the either of the list boxes than it should prompt a message that, please select an item to remove
If user selects one item in each of the listbox, than it should remove both of them

2)if i am swapping the value from one list box to another, it should make sure that it has no duplicate in the resulting list box.


0
Comment
Question by:srikanthv2322
  • 2
4 Comments
 
LVL 5

Expert Comment

by:roger_karam
ID: 34989157
Hello again srikanth,

Here are the additional checks. If you need any further small improvements, please feel free to post them in this same question (even after awarding any points).

-RK
listbox-combobox-v4.xlsm
0
 

Author Comment

by:srikanthv2322
ID: 34989326
Hi ,

I dont see the Remove Button and its validatons
0
 
LVL 5

Accepted Solution

by:
roger_karam earned 2000 total points
ID: 34989845
0
 
LVL 24

Expert Comment

by:Tracy
ID: 35225364
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question