xlf QandA series
VBA Visual Basic for Applications :: Excel
- ATP covariance code: - our team is trying to develop a VBA version of the ATP covariance dialog box. Where do we start?
- Count decimal places: - I want to count the number of decimal places in a text string. What VBA code do I need?
- Decimal place KB shortcut: Count decimal places: - is there a keyboard shortcut to change decimal places from the keyboard?
- Fit Excel window to 720p: - I need an easy way of setting the Excel window to 720p resolution for upload to YOUTUBE
- Floating point precision, and cell formats: - Why does the logical expression formula =0.1=(1.2-1.1) return FALSE?
- Holidays advanced filter: - is there a way to create a list of trading days from a table of public holidays?
- Implied volatility, Goal Seek and multiple options: - how can I estimate implied volatility across multiple options using Goal Seek without selecting individual instruments?
- Monte Carlo: function - why does my Monte Carlo based option pricing function show two different values in the function arguments dialog box?
- Trailing minus numbers - A UserForm TEXTBOX INCLUDES THE USUAL NUMBER VALIDATION TECHNIQUES, YET ACCEPTS A NUMBER WITH A TRAILING MINUS SIGN. HOW CAN THIS BE?
- Vector to array - how do I write the VBA code to link an array to a vector source?
- Worksheet: name exists - how can I tell if a worksheet name already exists in the workbook?
- Worksheet: sort - how do I sort worksheets from a range list index?
Ask a question
- Ask a Question - send a QUESTION to the xlf QandA series