Results 1 to 2 of 2

Hi. An Introduction/Timeline

Threaded View

dwc_civil_pe Hi. An Introduction/Timeline 11-24-2018, 02:23 AM
arlu1201 Hello dwc_civil_pe, ... 11-24-2018, 02:25 AM
  1. #1
    Registered User
    Join Date
    09-07-2018
    Location
    Chico, CA
    MS-Off Ver
    2016
    Posts
    0

    Hi. An Introduction/Timeline

    Hi! I am a retired civil engineer . I just poke my nose in once in a while to learn as I have not coded before and I'm trying to get an interactive timeline done while I still can. My goal is to make a timeline that will be useful to others and keep my mind busy.
    I have run the timeline past my neurologist and she definitely want's to see it when it is done and she has given me a deadline of 12/2018. I will attach a copy of it and will take any comments or suggestions that anyone has to offer. Any help would be much appreciated.

    So far I have the file opening on the correct page (Opening Page). I couldn't get the attachment to work however I have included the code for the command buttons.

    Private Sub CommandButton1_Click()
    BrthFrm6.Show
    End Sub
    
    Private Sub Doctors_Click()
    DrFrm5.Show
    
    End Sub
    
    Private Sub Mediccations_Click()
     MedFrm7.Show
    End Sub
    
    Private Sub Milestone_Click()
    EvntFrm7.Show
    End Sub
    
    
    Dim ws As Worksheet
    Set ws = Worksheets("Opening Page")
    
    'find first empty row in database
    iRow = ws.Cells.Find(What:="*", SearchOrder:=xlRows, _
        SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1
    'copy the data to the database
    With ws
    '  .Unprotect Password:="passwordTextBox2"
      Cells(iRow, 2).Value = Me.TextBox2.Value
      Cells(iRow, 3).Value = Me.TextBox6.Value
      Cells(iRow, 4).Value = Me.TextBox7.Value
    '  .Protect Password:="password"
    End With
    
    'clear the data
    Me.TextBox2.Value = ""
    Me.TextBox6.Value = ""
    Me.TextBox7.Value = ""
    Me.TextBox2.SetFocus
    Me.Hide
    
    End Sub
    Last edited by dwc_civil_pe; 11-26-2018 at 06:21 PM. Reason: forgot code indcatorsi

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple questions about Excel project timeline, % formulas, refresh timeline
    By Please Help in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-27-2016, 07:13 PM
  2. [SOLVED] Dated Timeline
    By lyla22 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-12-2015, 11:35 AM
  3. Making a Timeline
    By TheFriedert in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-12-2014, 11:06 AM
  4. [SOLVED] Timeline
    By rwab in forum Excel General
    Replies: 2
    Last Post: 07-22-2009, 02:20 PM
  5. Timeline
    By aftabn10 in forum Excel General
    Replies: 3
    Last Post: 06-16-2008, 09:53 AM
  6. Timeline
    By Nadi in forum Excel General
    Replies: 1
    Last Post: 11-29-2007, 10:09 PM
  7. Timeline graph?
    By Kytro in forum Excel General
    Replies: 1
    Last Post: 06-01-2006, 01:04 AM

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