Posts by stickyfeet

    Hi all,

    I've been trying to get a Timed MsgBox (eg every 30 mins), but I only want it to appear if a certain checkbox has been checked. Then if the checkbox has been unchecked the timed MsgBox stops.

    I've been pulling my hair out, and can't find any examples for this type of VBA.

    Can anyone help or point me in the right direction? any help is truly appreciated.

    Many thanks


    Hi it seems I've just been bitten by the VBA bug for the past few days I just can't seem to get away from my PC.

    Anyhow this is my first post so please be gentle.

    I wish to input data in one workbook and then want certain bits of this info to update in another workbook.

    I want this info to write to the next available line.

    This is what I've been playing around with, can someone please point me in the right direction.

    'Update the Stats File

    Set myBook = Workbooks.Open(Filename:="c:\Stats.xls")

    myBookRow = [c:\Stats.xls]!Sheet1.Range("A65536").End(xlUp).Row + 1

    Cells(myBookRow, 1) = Date
    Cells(myBookRow, 2) = Now()
    Cells(myBookRow, 3) = User
    Cells(myBookRow, 4) = Sys
    Cells(myBookRow, 5) = Des
    Cells(myBookRow, 3) = TextBox1.Value

    Thanks in advance.