Is this function possible in excel template?

[dagoof]

I use an old excel 2000 invoice template (I know, I'm sorry but my uses are simple and I hate the newer bloat-ware versions ). I currently have 3 radial check buttons which I've set for payment options; cheque, credit card, bank transfer. Depending which is selected I have a standard line of relevant text in the 'fine print' box below.

I was wondering if it was possible to add a function whereby the 'fine print' would change automatically, relevant to whatever option I check?

 

[dagoof]

That's excellent Saagar, got it working so thanks for the assist.

Don't suppose you know how to get rid of the 1004 runtime error 'unable to get drawing objects property of the worksheet class'?

 

[Saagar]

Glad to help.

Please copy paste the code that errors out. My guess is the code is referring to a drawing object that is either deleted or modified.

 

[dagoof]

That was a copy/paste of the error Saagar - it says:

Run-time error 1004:
'unable to get drawing objects property of the worksheet class'

Clicking on the first radio button never gives the error, just the other 2.

 

[Saagar]

Does it show the VBA code window and highlight the code that is failing?

 

[dagoof]

Just shows this - can't get into debug/VB editor:

 

[Saagar]

Hmm... try right clicking on the radio buttons and see if there is a macro assigned. Open Visual Basic Editor and see if there is any code in the macro assigned to the radio button.

 

[dagoof]

Doesn't seem to be any macros there and VB editor's just blank.

 

[Saagar]

Will you be able to email me the worksheet?

 

[dagoof]

Yes, thanks Saagar, if you PM me your address I will send it over.