View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jari.toukkari@jippii.fi is offline
external usenet poster
 
Posts: 3
Default Print / Write to text file and usage of buttons

Hi gurus

I need to make an Excel vba to write to a log text file usage of
certain buttons on a userform.

So, when user clicks a button called "button1" on "userform1" this
information should be added in the end of text file with date and
username.
There are two problems I can't solve and need you help with.
a) how to write an event to a userform so that any button clicked runs
program to save to log file.
b) how to append to the file. I have used print and write for other
purposes, but this should append and not overwrite.

This is against news rules, but could you pls send your comments to
jari.toukkari...jippii.fi because I have a limited access to news
groups.

Thanks in advance.
Jari