Results 1 to 3 of 3

Saved Value to another Cell if any Cell Value Changed

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    174

    Red face Saved Value to another Cell if any Cell Value Changed

    Hi Guys,

    Your golden hands really i need it.
    What is the code IF ANY Changing Cell Value in F9 (will be changed by scrollbar) then the value from cell F10 (as Calculation) will be saved to another cell (F11) ?
    I enclosed the attachment for reference.

    Below the code in UserForm1:
    Option Explicit
    
    Private Sub CommandButton1_Click()
    Dim PauseTime, Start, Finish, TotalTime, MyTime
    Do
        Start = Timer
        DoEvents
        Sheet1.[F4] = Start / (60 * 60)
    Loop
    End Sub
    
    Private Sub CommandButton2_Click()
    End
    End Sub
    
    Private Sub ScrollBar1_Change()
    
    Dim MyTime
    MyTime = Time
    Sheet1.[E5] = Format(MyTime)
    
    TextBox1.Value = ScrollBar1.Value
    Sheet1.[F9] = TextBox1.Value
    
    On Error Resume Next
    
    End Sub
    
    Private Sub UserForm_Initialize()
    ScrollBar1.Min = 0
    ScrollBar1.Max = Sheet1.[E9]
    ScrollBar1.Orientation = fmOrientationHorizontal
    ScrollBar1.SmallChange = 1
    ScrollBar1.LargeChange = 1
    ScrollBar1.Value = 0
    End Sub
    Thanks in advance for your helps and supports.

    Best Regards,
    Iqballhud
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 02-04-2015, 03:27 AM
  2. Replies: 7
    Last Post: 05-07-2014, 02:01 AM
  3. Non-Changed Worksheet asking to be saved
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-23-2009, 05:55 PM
  4. Saved as Changed
    By creekboy in forum Excel General
    Replies: 2
    Last Post: 11-23-2006, 11:31 PM
  5. Replies: 2
    Last Post: 02-24-2005, 07:06 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