# 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