Forum

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.

Hi Jomili, The variable Thickness is defined as a string but it should be a numeric e.g. Long Regards Phil

Hi Marsil, Have you tried to write the macro? I'm happy to help you out if you get stuck but I'm sorry I don't have time to write things from scra...

Hi, Both types on controls provide similar functionality : radio buttons, check boxes, lists etc. Form Controls come as a standard part of the E...

Hi, I haven't done this before but you may be able to use TransparentBackground to check if the image has any transparency I'm not aware ...

No worries, good luck.

In each country specific sheet, create a pivot table for that country. Info on creating and working with Pivot tables here then create your char...

Hi Kai, You can extract as many elements as you want from a web page. The issue is how easy that is to do, and that depends on how the web page is...