201 reputation
18
bio website
location
age 31
visits member for 3 years
seen 5 hours ago

8h
awarded  Yearling
9h
awarded  Teacher
9h
answered VBA code to change the selection of a drop down list (combo box)?
10h
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.
10h
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.
10h
awarded  Editor
10h
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.
10h
comment VBA code to change the selection of a drop down list (combo box)?
@CharlieRB edited
11h
revised VBA code to change the selection of a drop down list (combo box)?
added 26 characters in body
11h
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?
Nov
23
asked Google Inbox - show bundled messages once a week on a day other than Monday 7am?
May
16
accepted Can I make Excel beep when a calculation is finished?
May
12
awarded  Nice Question
May
9
awarded  Popular Question