+ Reply to Thread
Results 1 to 2 of 2

Userform with pages to push/pull various data from/to worksheet

Hybrid View

  1. #1
    Registered User
    Join Date
    02-11-2014
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    61

    Userform with pages to push/pull various data from/to worksheet

    Hey all,

    There may be a really easy solution to this that I'm just not seeing, but I am still fairly new to VBA so bare with me.

    So I have a userform like so:

    Userform.PNG

    This coding was made with some help when I only had a one day date and page:

    Set DateExists = Sheets("Schedule").Range("B:B").Find(what:=DateBox.Text, lookat:=xlWhole)
    
    If Not DateExists Is Nothing Then
            UpdateRow = DateExists.Row
            OvernightAM.Value = Cells(UpdateRow, 3).Value    'These are the drop boxes
            Breakfast.Value = Cells(UpdateRow, 4).Value
            DayBox.Value = Cells(UpdateRow, 5).Value
            Night.Value = Cells(UpdateRow, 6).Value
            OvernightPM.Value = Cells(UpdateRow, 7).Value
        Else
            OvernightAM.Value = ""
            Breakfast.Value = ""
            DayBox.Value = ""
            Night.Value = ""
            OvernightPM.Value = ""
    This allows me to either be shown a name if it's already on the system, or i can create/edit it and I use the 'Okay' button to save it.
    (I don't think that part of the coding is relevant, but I can send the whole thing if need be)

    Now my question is how could I extend this to the other pages?

  2. #2
    Registered User
    Join Date
    02-11-2014
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    61

    Re: Userform with pages to push/pull various data from/to worksheet

    Anyone have any suggestions?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to push pull data from a workbook by name to a master workbook
    By gizmojeff in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2014, 11:36 AM
  2. How to pull data from main worksheet into other pages in same book
    By ESUCP Jamie in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 06-27-2013, 05:05 PM
  3. want to pull in data from multiple web pages
    By arcam2004 in forum Excel General
    Replies: 0
    Last Post: 07-17-2012, 08:01 PM
  4. [Solved] Pull or Push data from one workbook to another
    By Brie in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-12-2010, 11:31 AM
  5. push instead of pull data?
    By adm in forum Excel General
    Replies: 5
    Last Post: 06-03-2009, 06:43 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