Results 1 to 21 of 21

Userform Edit Record and GoTo record Command Buttons

Threaded View

139runner Userform Edit Record and GoTo... 06-05-2014, 01:10 PM
Tinbendr Re: Userform Edit Record and... 06-05-2014, 01:38 PM
139runner Re: Userform Edit Record and... 06-05-2014, 02:19 PM
Tinbendr Re: Userform Edit Record and... 06-05-2014, 02:44 PM
139runner Re: Userform Edit Record and... 06-05-2014, 04:08 PM
139runner Re: Userform Edit Record and... 06-09-2014, 07:45 AM
139runner Re: Userform Edit Record and... 06-09-2014, 07:37 AM
Tinbendr Re: Userform Edit Record and... 06-09-2014, 09:21 AM
139runner Re: Userform Edit Record and... 06-09-2014, 11:01 AM
139runner Re: Userform Edit Record and... 06-11-2014, 01:17 PM
Tinbendr Re: Userform Edit Record and... 06-11-2014, 01:36 PM
139runner Re: Userform Edit Record and... 06-11-2014, 03:47 PM
Tinbendr Re: Userform Edit Record and... 06-12-2014, 08:46 AM
139runner Re: Userform Edit Record and... 06-12-2014, 02:09 PM
Tinbendr Re: Userform Edit Record and... 06-12-2014, 02:29 PM
139runner Re: Userform Edit Record and... 06-13-2014, 07:12 AM
Tinbendr Re: Userform Edit Record and... 06-13-2014, 08:05 AM
139runner Re: Userform Edit Record and... 06-16-2014, 10:30 AM
patiinh Re: Userform Edit Record and... 04-29-2020, 03:30 AM
FDibbins Re: Userform Edit Record and... 04-30-2020, 12:22 AM
patiinh Re: Userform Edit Record and... 04-30-2020, 12:54 AM
  1. #1
    Registered User
    Join Date
    06-04-2014
    Posts
    13

    Userform Edit Record and GoTo record Command Buttons

    I have created a Userform in Excel and have never used Visual Basic before but through the help of these forums, not doing too bad.
    Issue 1) When writing the data to my worksheet for CheckBox info it is stored in the worksheet as true or false. I would prefer it to store as the checkbox title. My checkboxes are for weather and I would rather fog, snow, rain, etc be stored as opposed to true or false.
    Issue 2) I have code for making sure a value is numeric to store phone numbers but you have to enter 1112222 without a hyphen is there a better way to do this or should I remove the numeric requirement.
    Issue 3) Now I need some code for a Goto Record and and Edit record Command Button.
    Any help would be appreciated. I will upload exisiting code.
    Issue 4) Any formatting suggestions for 24 hour clock time format, I took out what I had as it stalled every time I ran it.
    Attached Files Attached Files
    Last edited by 139runner; 06-05-2014 at 02:26 PM. Reason: remove file and add correct file

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Userform Edit/Update record help
    By sa.1985 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-20-2013, 10:29 AM
  2. Replies: 1
    Last Post: 11-16-2012, 09:25 AM
  3. Command Buttons for Viewing Record, Next Record and Previous Record
    By david1987 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-23-2012, 06:30 AM
  4. Goto Record when Duplicate Record Exists
    By rlsublime in forum Access Programming / VBA / Macros
    Replies: 6
    Last Post: 03-29-2012, 11:13 AM
  5. Create Next /Previous command buttons also Modify existing record in a Userform
    By rabalam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2012, 04:10 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1