+ Reply to Thread
Results 1 to 2 of 2

How to save a value in a text box as a Default for this text box in Excel form?

Hybrid View

  1. 04-21-2005, 12:56 PM #1
    surotkin
    surotkin is offline
    Registered User
    Join Date
    03-16-2005
    Posts
    20

    How to save a value in a text box as a Default for this text box in Excel form?

    Hello everyone,
    does anybody know how to save a value as a Default of a text box in Excel form? So when you open the Excel form next time, it will remember the last entered value.
    I use Show and Hide methods for Excel forms.
    I did not find any Open method with Design mode to save the last entered value as a Defaullt.
    Thank you.
    surotkin
    Reply With QuoteRegister To Reply
  2. 04-22-2005, 09:36 AM #2
    MartinShort
    MartinShort is offline
    Forum Contributor
    Join Date
    04-11-2005
    Location
    London
    Posts
    259
    At the end of your combo change (which we will call "ComboBox1") routine, save the selection the user has made to a cell (eg A1). 
    Range("A1") = ComboBox1.Value
    In the initialisation routine for your form, type 
    ComboBox1.ControlSource = Range("A1")
    and it will automatically place the contents of A1 into the combo box.

    MS
    Last edited by MartinShort; 04-22-2005 at 11:11 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1