UserFrom, Command Button and Cell Contents

[Valdrin]

Hi All

I have a what I think to be an advanced question. I have a number of columns with containing case data. These cases need to be uodated on a regular basis. Currently using ALT+Enter to add linar text updates in cells under a column called Status Update. What I would like to do this:

1- Select a cell then click a command button.
2- Clicking command button opens up a VBA form. Form contains one text box and one button called update. The text box should ideally be pulopulated with the existing cell value.
3-On clicking update the entire text box contents should be inserted into selected cell.
4- Ideally there should be a date to indicate when the text was entered but this can be manual.

What do you think?

 

[Norie]

Sounds perfectly do-able, couple of things though.

1 Wouldn't double click be better to fire the userform?

2 Is it restricted to a particulare column/range/row?

3 Where would the date go?

 

[Valdrin]

Sounds perfectly do-able, couple of things though.

1 Wouldn't double click be better to fire the userform?

2 Is it restricted to a particulare column/range/row?

3 Where would the date go?

Hi Norie

The button is needed coz the user first selects a cell containing a value. Where the cell is or what the value is, is not important. Once the cell is selected the button is clicked by the user and the contents of the cell appears into the form text box so it can be amended or more added to it. To finish the user clicks update on the form to populate the amended text back into the previously selected cell.

The date would nice if I could somehow date stamp that an amendment was made to the cell contents.

Thanks