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?
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?