Search results for query: *

Hi, simple question. Working woth Excel XP VBA I have a number comprised of 4 characters and 8 digits ex aaaa44044444 the seventh digit corresponds to the first number of the month part of a date. I want to validate this number. It cannot be anything but one or two or five or six. You may be...

Man thx Geof but this seems very complicated to me. I thought it would be more simple. Wouldn't there be a more simple way to develope a search engine?? I aggree that sql would have to be the most efficien way but its also very dificult to program. Is there any other way to do this?? Thx a...

and how do I use data/get external data if the data is in the same workbook??? Thx again

Hi Skip I like where your heading and sory for the delayed response. Do you think I could get this to work? The thing is that my table increases in size with every patient entered. I have a named range which automatically adjusts to the new additions. Remenber that my search values are gotten...

Can anybody here give me any tips on creating a search enfine? I have a list inside a worksheet and I want to search through it with a possibility of five different criteria on a userform. Is there anything that could help me?? I dont want to program each possibility but have something more...

thx for the reply skip. I`ll try that And for the search engine. Any tips on how to create an efficient one? Thx

Hi, Using Excel XP VBA I just want to know if its possible to have a sub procedure receiving lets say six arguments. These are arguments to perform a search on a list. These six arguments may or may not be all there. For example a person may want to search by name and leave the other...

Using Excel XP Hi, I have a userform that contains a textbox. Other textboxes will update themselves using data entered to this textbox so i have to make sure the format is good. Lets say I want this format aaaa99999999 how would I go about doing this. I want four characters and eight...

Thx for the reply Loomah. Remember that I'm not one field but all the fields in the same line. And why range("A1")? Wouldn't that just sort one cell? Thx for the reply

Hi, using Excel XP I have a small vba applicaiton that loads a form on start. This form is used to add clients. I want to update an existing list located on a worksheet of the same workbook with a new entry. This entry has to be placed in the correct alphabetic location in the list. Here's...