Forum

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...

Hi Aija, To do what you want just duplicate the IF statement in the sub for each cell you want to test, and change the cell references accordingly ...

Hi, You can use events to detect when new data is entered into the sheet, and then use VBA to copy that data elsewhere. Rather than use a separa...

Hi Aija, doing something like this is certainly feasible. You mention coding but I don't think VBA is required, you can just use functions. I...

Hi Kai, Nothing is attached 🙁 Please attach a workbook with code rather than an image of that code. Regards Phil

Hi Phil, I'm confused. The Voucher Removal form is to enter data? Not to delete a record? When you say the voucher is 'removed', do you mean i...

Please supply your workbook and data so we can see what you are working with. Otherwise we have to recreate everything from scratch and this probably...

Hi Junko, I could not find anything wrong with what you did, that is an odd problem. But to get it working I copied your function, renaming it o...

Hi Philip, Can you provide your workbook with the form and data please. Regards Phil