Solved

Error Validation on Two ListBoxes

Posted on 2011-02-26
5
228 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 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 500 total points
ID: 34989845
0
 
LVL 24

Expert Comment

by:broomee9
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
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…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

726 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