Automatically insert text if a box is selected.

[energym]

Automatically insert text if a box is selected.
I have a spreadsheet action plan with required procedures should a box be ticked. Is there a way to automatically insert the procedures elsewhere on the spreadsheet if I 'tick' a box for that required action.
I am trying to cut down on man hours, flipping between sheets and using the copy/paste functions.

Many thanks.

[dilipandey]

Hi energym,

Please share the workbook and the text ? thanks

Regards,
DILIPandey
<click on below * if this helps>

[energym]

Hi,

Thanks for your reply. The example sheet I have attached is vague I am afraid due to customer confidentiality.

At the moment I have customer data surveys that require an action depending on the answer.

I am continually using 'copy and paste' to paste in the action for the relevant answer.

Is there an easier way to do this or am I looking at another program?

Cheers.

[dilipandey]

Sorry.. I am still not getting what you want to achieve.
I believe you have data as you shown in column A,B,C and your expected results would be data in column F,G,H.. correct?
I can see you transposed the data in column F & G but from where you got data in column H?


Regards,
DILIPandey
<click on below * if this helps>

[IGEDIT]

You would require as many tick boxes as there actions. A better way would be to use a list box containing all the actions and a command button which would act on the selected listbox item selected using Select Case...End Case on either the item string or item index.
By the by, are you a night hawk or do you work shifts?

[energym]

Thanks for the replies. IGEDIT has the idea of what I want to do.

I want to produce 1 form, which displays the actions I highlight in another workbook.

" A better way would be to use a list box containing all the actions and a command button which would act on the selected listbox item selected using Select Case...End Case on either the item string or item index."

Is there any where with decent instructions I can follow?
I am not as up to speed as yourself!

Not a nighthawk or a worker of shifts. Are you referring to my time of posts? Live in the UK.

Thanks for all the help.

[IGEDIT]

have attached your original example sheet with some added code which may help. Play around with this and let me know how you get on.Code Forum Example.xlsm