Forum

Hi, I'd usually look to do something like this using a Worksheet_Change event but unfortunately changing the colour of a cell does not trigger a ch...

1. Select the Format icon (the paint roller) 2. Click on Y-Axis to expand it 3. Scroll down and click on Title to toggle it off/on Regards ...

Hi, Please supply your workbook and data and a clearer explanation of what it is exactly you want to happen. Please supply as much information...

Hi, That saved search link takes me to a page that requires a login. We'll also need to know exactly what information you want from the page(s) ...

Hi Aye, I can't open that doc, Word tells me there's something wrong with it, and the file size is only 162 bytes. You can just upload an image ...

Hi Sara, I'd highly recommend that your data is organised into a tabular format and create a table so that reporting and formulas can work more easi...

Hi Sean, No workbook is attached. Regards Phil

Hi Fatou, I don't know why the 5's have an extra character in the data returned by the form. It looks like a CR (carriage return) not quotes. I ...

You need to use the MAXIFS function and convert your data into a table so you can use structured references rather than address entire columns. See a...

Hi, The file you attached is an XLSX so it can't store VBA. You need to save the file as an XLSM to store and run VBA. Try opening the workbook...

No worries Tom. Glad that we can help and great to hear that it's had a positive impact at your work. All the best for 2020. Regards Phil

Hi Tom, In the attached workbook I've created a form that will search a table to match a record number, then populate the form fields with the data...

Hi, I wrote this code Is this what you are using? Can you please attach your workbook with the code. Regards Phil

VBA allows implicit conversion - converting one data type to another - and it handles the type conversion. So when you assigned a number to a string,...

🙂 No worries. I think all (?) the constants in VBA are numeric values.