Option Box & Scroll Bar Help

**pauldaddyadams** · 05-31-2012, 05:21 AM

Hi

This is the first time I have used option boxes and scroll bars so I am in need of some help please...

The user has the option of selecting 8 boxes. Depending on the option selected I need the relevant column retuned from row 11 – this should go in cell C9

e.g. If the option box in column L is selected then Cell C9 would return £0.83 (this is from cell L11).

The added complication is that if the option box in column S is selected then the scroll bar comes into play. Here the user has the option of selecting Full/Half/None. If It is full then the value of C9 should be £0.20 (from cell S11), if its half then this should be S11 dived by 2 and if zero it should be zero.

I hope this is clear I have uploaded a detailed example – can anyone help?

**martindwilson** · 05-31-2012, 05:51 AM

changed a few things for you

**john55** · 05-31-2012, 06:04 AM

see if it helps you

Sub OptionButton3_Click()
[c9] = [m11]
End Sub
Sub OptionButton2_Click()
[c9] = [l11]
End Sub

' please continue for the rest of buttons

Sub OptionButton9_Click()
Select Case Range("c7").Value
Case Is = "Full"
[c9] = [s11]
Case Is = "Half"
[c9] = [s11] / 2
Case Is = "None"
[c9] = "0"
End Select
End Sub

**martindwilson** · 05-31-2012, 06:06 AM

oh another coder lol, functions over code any time!

**pauldaddyadams** · 05-31-2012, 06:11 AM

This is brilliant! I am always amazed by the helpfullness of some members!

Thanks Martin!!

**john55** · 05-31-2012, 06:12 AM

Hi Martin, I am really sorry....I did not refresh the page!
I am sorry!

Option Box & Scroll Bar Help

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Option Box & Scroll Bar Help

Re: Option Box & Scroll Bar Help

Re: Option Box & Scroll Bar Help

Re: Option Box & Scroll Bar Help

Re: Option Box & Scroll Bar Help

Re: Option Box & Scroll Bar Help

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions