"Anthony" wrote in message
...
Hi all,

Can anybody provide some code (as I am still new to this) that will
execute
the following tasks

Please let us know what version of Excel you are using


1) call the private macro called Private Sub CommandButton1_Click()

How do you want to execute the macro? From a toolbar button? From a shortcut
key? From the macro menu?

2) take the result from the above macro (which would be placed in the next
available row in column B in Sheet 1) and place it into the next available
row in column A of DATA worksheet

Post the code you are using, so folks here can help you.

3) run the frmNewJob userform

frmNewJob.show


any help appreciated and thanks in advance