Excel VBA Forms Part 8 - Option Buttons

By Andrew Gould

[hadireg]

Simply the best tutor on the planet! Thumbs up!

[TsiriniainaRakotonirina]

That importing Data into your Excel Spreadsheet was WAOOOOW. I thought I knew Excel, but no you told me how far I still am.
Thank you for your teaching. Very nice and very clear. You gained my Subscription and my Thumbs Up!

[costageorghiades]

I was pulling my hair out!! Thank you this tutorial was extremely helpful.

[carlosferreira]

I just want to say thank you for the videos all those very good.

[DolceKar]

This guy is excellent... If you are reading this, or any Excel VBA expert for that matter, I am struggling to link an Option Button that drives selective data from a column. I couldn't find much tutorials on this. I know what to do, it's VBA language what I don't master. Basically is button A is selected, column 1, rows 1, 2, 3 are displayed in a combo box. When button B is selected, rows 4, 5, 6 are the the items listed in the same combo box and not 1, 2, 3.. any ideas?

[chuksmosindi]

I'm enjoy your tutorials but how can I write a code with option buttons that chooses between two forms that add data to worksheet, option1 to show a form and option2 for another form

[krn]

Thanks. If no amt is shown in gross can you also remove the focus from the option button?

[michaelhuis]

Hello WiseOwl,

First:
Thank you very much for putting this video's online! Its realy nice the way you explain everything! Keep up going the good work!

Second:
When adding the data "from web" into the Excel sheet something strange happend.

Some of the currency's are displayed as:
Euro > US Dollar 1 > 1.045.194 (1 million, 45 thousand, one hundred ninety-four But this have to be 1.045194 instead of 1.045.194)

But in the same table the Pound is correct.
Euro > Brittish Pound 1 > 0.850789

It seems that the same table added to my sheet converts two kinds of data? Is there anything i can do? I try to loaded it other sheets, workbooks etc. but nothing realy happend.
I even downloaded your added file from you website and refresh the data and the same thing happend :/

[erikainks]

Question:
I have a user form that has both edit and add mode. In add mode I would like to select the option button to input a date in my preselected cell. however, when I transition to edit mode and filter through my rows the option button resets (in other words, it replaces the original date with the date that I am editing...ie the current date). I would like to know how to keep the original dates when editing.

my code:

Private Sub optstartdate_Click()

If optstartdate.value = xlOff Then
.value = ""
Else
.value = Date

End If


End Sub

I am not sure how to code this issue.... please any help would be most appreciated.

Thank you so much for these videos- they have been a real lifesaver!