201 reputation
18
bio website
location
age 32
visits member for 3 years, 2 months
seen yesterday

Jan
1
asked Zoom in on Excel 2010 print preview
Dec
19
awarded  Yearling
Dec
19
awarded  Teacher
Dec
19
answered VBA code to change the selection of a drop down list (combo box)?
Dec
19
comment VBA code to change the selection of a drop down list (combo box)?
@Raystafarian I have a different spreadsheet where if the user clicks a button and a bunch of conditions exist it will change the drop-down selection to reflect visually that something happened in VBA.
Dec
19
comment VBA code to change the selection of a drop down list (combo box)?
@Raystafarian I just made a new spreadsheet with a combo box, referencing 3 cells for selections options "1","2","3", and tried recording a macro of me changing my selection. And no code was recorded.
Dec
19
awarded  Editor
Dec
19
comment VBA code to change the selection of a drop down list (combo box)?
@Raystafarian I googled a bunch and found details about changing the data validation, but didn't see anything about changing my selection.
Dec
19
comment VBA code to change the selection of a drop down list (combo box)?
@CharlieRB edited
Dec
19
revised VBA code to change the selection of a drop down list (combo box)?
added 26 characters in body
Dec
19
asked VBA code to change the selection of a drop down list (combo box)?
Dec
10
comment Is there a way to include “workbook” event functions in my personal macros file?
Very interesting! Though I have other macros in the workbook that I'd like other users to use as well...
Dec
10
awarded  Commentator
Dec
10
comment Is there a way to include “workbook” event functions in my personal macros file?
@RubberDuck But I only want it to beep for me, not for other users who open and save the spreadsheet.
Dec
10
comment Is there a way to include “workbook” event functions in my personal macros file?
@RubberDuck really just make it beep. I want to know when a (sometimes) long calculation is finished. This particular event function doesn't work from my personal workbook.
Dec
10
asked Is there a way to include “workbook” event functions in my personal macros file?
Dec
10
asked Can I run a VBA function whenever excel calculates, even when I don't click F9?
May
16
accepted Can I make Excel beep when a calculation is finished?
May
12
awarded  Nice Question
May
9
awarded  Popular Question