[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Error Validation on Two ListBoxes

Posted on 2011-02-26
5
Medium Priority
?
231 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 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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

656 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