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
SF
Re: Updating info from one workbook to another
Andy
Firstly thanks for the welcome and secondly thanks for the help.
It works a treat. Fantastic. I was struggling with it last night and earlier today.
Its near enough complete. Once again a big 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.
[vba]
'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
[/vba]
Thanks in advance.
