Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: GoKingBee
  • Content: Threads
  • Order by date
  1. GoKingBee

    Open Find dialogue box in a range

    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...
  2. GoKingBee

    Delay the completion of a macro

    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...
  3. GoKingBee

    Formatting date in TextBox doesn't stick

    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...
  4. GoKingBee

    Calendar 9.0 Object - won't default to Todays date

    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...

Part and Inventory Search

Back
Top