Search results for query: *

The user was having a lot of problems with other things on the computer as well so I suggested that they take it in to a repair shop. The shop fixed most of the problems ... one of them being the multi-doc problem. What it was was the alternative startup location. BUT, the thing is ... I have...

If I want to only Search the Last Name column I still have to set the Range("a:a").Select. Now how would I get it to "Unselect" the Range AFTER I have completed the search? Pronunciation: 'lO-kE Function: noun Etymology: Old Norse Definition: a Norse god who contrives evil...

Neat. Thanks for the tip Loomah. Less is best. :) Pronunciation: 'lO-kE Function: noun Etymology: Old Norse Definition: a Norse god who contrives evil and mischief for his fellow gods

If you are going to use Gorth's method make sure to add "Application.ScreenUpdating = True" to the end of the macro to turn ScreenUpdating back 'on'. Pronunciation: 'lO-kE Function: noun Etymology: Old Norse Definition: a Norse god who contrives evil and mischief for his fellow gods

Ok I was given the coding that I was missing. It seems that SendKeys needs to have Sheet1 in "Focus". So the full, correct coding to make this work is: Sub Find() Range("B1").Select Application.SendKeys ("^{f}") End Sub Hope this will help others out...

Matt .. THANK YOU VERY MUCH!!!! wooohoo! I just posted something about this (because I figured this post was a dead topic now) and then you answered my question here. :\ /does the happy dance. I had all of the coding except for the Range bit. I didn't realize that SendKeys needed to have...

Using Excel97 ... I have created a spreadsheet / database with a number of buttons to do different things. One of those buttons I have assigned to a macro called "Find". The coding (placed in Module2) is as follows: Sub Find() Application.SendKeys ("^{f}") End Sub The...

heh. I have a spreadsheet that I created for a user. In that spreadsheet I have several custom buttons that I have added (call them button1, button2, button3, etc.). They are all Command Buttons created using the Control Toolbox, and selecting Command Button, thereby allowing me to code them...

If you press CTRL+F it brings up the Find Dialogue Box with the blinking cursor waiting for you to enter something. That is what I am looking for. I want to basically assign CTRL+F to a Command Button. I hope that clarifies for you. Pronunciation: 'lO-kE Function: noun Etymology: Old Norse...

Is there any way to bring up a blank Search Dialog so that a user can enter their Search Parameter in themselves? I have created a spreadsheet (Excel97) and I would like to have a Search Button that when clicked brings up the Find (CTRL+F) function where the user can then enter a client's Last...

Ok, thanks folks I will give those a try tonight. Wray that article seems like a good start because the user DOES have WinFax installed on their computer and it was installed after Excel was. I will keep you all posted. Pronunciation: 'lO-kE Function: noun Etymology: Old Norse Definition: a...

Well finally managed to get access to the users computer and did as suggested by the both of you. It didn't work. So I went in to Tools>Options and selected "Ignore Other Applications" on the off chance there was something trying to impose itself on Excel (the user also gets an error...

Harsh Zathras, harsh. :( I have difficulty getting across what I want. I will endeavour to detail out sufficiently what I am looking for in the future. :) Please don't not answer my posts in the future as I value everyone's input. I learn more and more from every post. Ken thank you that...

The problem with that is that I will be using another part of the spreadsheet (as yet undefined) for other information and I don't want those rows selected. Plus I have the Title of the spreadsheet, a few buttons, etc... When I tried the code you provided it highlighted from the last row of...

Otay ... I've searched high and low for the answer to this and haven't been able to come up with the last bit of coding. Using Excel 97. A B 1 Client1 George 2 Client2 Peter 3 Client3 Henry . . . The user enters records in to the spreadsheet / database. There is no set...

heh. I prefer the "too much blood in my caffeine stream" excuse. ;) NEVER use age as an excuse. Not good. :D Pronunciation: 'lO-kE Function: noun Etymology: Old Norse Definition: a Norse god who contrives evil and mischief for his fellow gods

Sweet. You guys (and gals) rock. I amended to code slightly to force the Alpha characters to UpperCase. Here is the amended code: =IF(ISBLANK(D1)," ",UPPER(LEFT(B1,3))&IF(DAY(D1)>9,DAY(D1),"0"&DAY(D1))&IF(MONTH(D1)>9,MONTH(D1),"0"&MONTH(D1))&RIGHT(YEAR(D1),2))...

One more thing. If the "First Visit" field is blank (either because the person entering the data doesn't know the "First Visit" date or is not yet at that field) is there any easy way to keep the "ClientID" field BLANK? I want to keep the "confusion...

Sorry about that. I don't post here too often so I tend to not think about what I should and should not put in the post. I am using Excel 97. And your Formula works beautifully Pronunciation: 'lO-kE Function: noun Etymology: Old Norse Definition: a Norse god who contrives evil and mischief...

Hi folks, I have a "dateabase" where I have a 4 columns (as below): ClientID Last Name First Name First Visit SMI140902 Smith John 14/09/2002 Currently the ClientID field is manually populated by the user. What I would like is for the field to automatically...