Results 1 to 7 of 7

passing textbox values between forms

Threaded View

  1. #5
    Registered User
    Join Date
    02-13-2013
    Location
    United Kingdom
    MS-Off Ver
    MS365 MSO Version 2211
    Posts
    18

    Re: passing textbox values between forms

    Rory,
    if I used one form, with multipages, how would I call up the specific pages ?

    this is how I currently get my unique record number and date...
    basically go to last row (that has content) and add 1...
    Private Sub UserForm_Initialize()
    Dim irow As Long
    Dim ws As Worksheet
    Me.Width = 340
    Set ws = Worksheets("CUSTdb")
    'find last row in database
    irow = ws.Cells(Rows.Count, 1).End(xlUp).Row
    Me.reg1.Value = ws.Cells(irow, 1) + 1
    Me.reg2.Value = Format(Date, "mm/dd/yyyy")
    
    
    End Sub
    How do I set a variable to "lock" that record number throughout the userform data collection so that I can just use textbox_record_num.value = xxxx
    where xxx is the formula to go get the record that i am actually working on...



    so how do I now call
    Last edited by bigfatpies; 07-21-2014 at 08:45 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] passing Option button result to textbox
    By tigerdel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2012, 02:35 AM
  2. Passing data between forms
    By JamesPLile in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2011, 10:36 AM
  3. passing variables between 2 forms
    By burl_rfc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-14-2006, 12:55 AM
  4. [SOLVED] Formatting Textbox, passing values to worksheet
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-06-2005, 09:00 PM
  5. Passing variables between forms
    By Sami82 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-07-2005, 07:12 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