UserForm Questions

Hi,


Firstly, I need to create a Box in a UserForm which will allow me (by clicking on it) to select any Cell, in any sheet.

Then, by clicking on a command button, I have to transfer Text from my TextBox to this Cell and clear the TextBox (and reset the counter - see below).


Also, I need to create a counter (will explain more in a sec) for the number of operations I have done using my UserForm.

Let's say I press my Calculate button once, it will write some text in my TextBox with the number 1- infront. If I do it another time, it will write 2- (and text).

So it should look like this :

1 - "Random Text"
2- "..........."
3- "Etc..."


If you need more information (as this may not be very clear) please let me know.

I just noticed I should have explained the 2nd macro in first and vice versa. It's easier to understand and it should be done in that order anyways.