Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validating user input to a listbox
I've a 2 col multicolumn listbox. Col1 holds values
code has taken from the workbook. Col2 values are the result of user input into a textbox. Col1 values have been used to name sheets in a new workbook The Col2 values will be used to rename the respective Col1 named sheet. As I see it, before user leaves the form, I will need to check Col2 as follows : a) that all entries are filled b) that all values are valid c) that all entries are unique .....that's all I can think of.........? User exits the form with 'Cancel' or 'Ok' buttons. Where can I learn something of these techniques please? Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validating user input to a listbox
How about if the new names are legal?
How about if any of the new names are already in use? Sheet1 becomes sheet2 sheet2 becomes sheet3 sheet3 becomes sheet1 As soon as you try to rename sheet1 to sheet2, trouble will occur. (I guess the user shouldn't have to worry about that. You'll have to do something in your code to make sure you rename them nicely.) I think I'd rename each to a temporary unique name and then come back and rename them nicely. (I'm sure you'll find more things to check--right after you release version 1.0!) Stuart wrote: I've a 2 col multicolumn listbox. Col1 holds values code has taken from the workbook. Col2 values are the result of user input into a textbox. Col1 values have been used to name sheets in a new workbook The Col2 values will be used to rename the respective Col1 named sheet. As I see it, before user leaves the form, I will need to check Col2 as follows : a) that all entries are filled b) that all values are valid c) that all entries are unique ....that's all I can think of.........? User exits the form with 'Cancel' or 'Ok' buttons. Where can I learn something of these techniques please? Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validating user input to a listbox
Stuart
: a) that all entries are filled You just cycle through all the entries and test the len of column two to be greater than zero. b) that all values are valid Maybe try to insert the sheet into the existing workbook and rename it. Use error checking to see if you get an error, and which error you get. If you don't get an error, delete the "temporary" sheet. c) that all entries are unique You could put all the names in a collection with their name as the key value, then compare Collection.Count to the number you should have. -- Dick Kusleika MVP - Excel www.dicks-clicks.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validating user input to a listbox
Many thanks to you both.
Regards. "Dick Kusleika" wrote in message ... Stuart : a) that all entries are filled You just cycle through all the entries and test the len of column two to be greater than zero. b) that all values are valid Maybe try to insert the sheet into the existing workbook and rename it. Use error checking to see if you get an error, and which error you get. If you don't get an error, delete the "temporary" sheet. c) that all entries are unique You could put all the names in a collection with their name as the key value, then compare Collection.Count to the number you should have. -- Dick Kusleika MVP - Excel www.dicks-clicks.com --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prompt user for input and utilize that input | Excel Worksheet Functions | |||
listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
User form with a listbox | Excel Programming | |||
Get User Input | Excel Programming |