Search results for query: *

Who would have thunk it. Thx alot Bill

Thanks to both for your replies - Tony, you were right on the money. What kind of source could I look at to find other such simple commands as this? I think they would be very useful to a new VBA person like myself. Bill

I am sure this is simple, but I can't seem to figure it out. I am trying to write VBA code to open the Find dialogue box. The part I am finding tricky is, I only want a certain range searched for the value the user is seeking. I can record a macro to select the range and initiate the Find...

OH! Now I get it. My thanks to everyone who provided assistance. Sometimes the simplest idea is the best. In this case the idea that PHV offered did the trick. By deselecting Backgroung Refresh the macro naturally waited until the Refresh was complete before executing the next line of code...

Thank you to all who responded to my question. I am a novice VBA writer and am having trouble deciphering your suggestions and how they would fit into my code. Here is my code: Sub UpdateTenderFields1() Sheets("Milestones").Select ActiveSheet.Unprotect Range("A4").Select...

I have a spreadsheet that accesses an external datasource using MSQUERY. I have written a macro that will REFRESH the data from the datasource. As you know this can take up to 20 seconds to complete. The spreadsheet is Worksheet Protected. Part of the macro is to Unprotect the worksheet...

Well Well - your idea worked. The only thing I need to do now is write some additional code to rewrite the text formatted date to a date formatted date. thx Bill King

The format of the spreadsheet cell is: dd-MMM-YY It doesn't seem to matter what format the cell is - the userform textbox still changes to mm/dd/yy Bill

I am populating a TextBox with a date. The TextBox is linked to a field on my spreadsheet. I use the code as follows: FormName.DateTextBox.Value = format(now(),"dd-mmm-yyyy") The problem is, as soon as I leave the TextBox the date format reverts to "mm/dd/yy". Is there a way to have the...

I am a new VBA for Excel programmer (self proclaimed). I am having trouble coding the Calendar object 9.0 to default to Today's date when the calendar is opened. I used code that forces the value of the object to equal NOW(), but this, in effect, disables the calendar object. Any date you...