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

16h
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.
16h
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.
16h
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.
16h
comment VBA code to change the selection of a drop down list (combo box)?
@CharlieRB edited
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
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.
May
9
comment Can I get Copy and Paste to note transpose, exactly as happens in Cut and Paste?
@Madball73 Yeah, that's what I've been doing. I wish there was an easier way.
May
8
comment Can I make Excel beep when a calculation is finished?
@techie007 I'm using formulas. I'll press F9 after a bunch of work and have to wait.
May
8
comment Can I make Excel beep when a calculation is finished?
@techie007 not VBA. Just functions in large Excel spreadsheets.
May
8
comment Can I get Copy and Paste to note transpose, exactly as happens in Cut and Paste?
Hmm, not really what I was looking for, but thanks.
May
8
comment Can I get Copy and Paste to note transpose, exactly as happens in Cut and Paste?
@Excellll I suppose. But what If I wanted to simulate absolute references for just one quick copy and paste, and then leave them as they were?
Dec
8
comment How to add Hebrew vowels in Word 2010
I didn't see anything there about vowels (nekudot) though. I know they're supported in later versions of word because when I open up old files from previous versions they display fine.
Jul
23
comment Two subscripts in Word 2010
Yes exactly. These things are very common in math. mathbits.com/MathBits/TISection/Algebra1/Probab14.gif
Apr
14
comment How to show time of day (7:42 AM) in VLC fullscreen mode?
Windows 8. Any hacks?