Forum

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

Hi, I don't have the same issue when I insert an ActiveX button. Please supply your workbook so we can have a look. Regards Phil

Hi John, I've reattached the file, please try again. Phil

Hi Leeroy, there is no file attached. Regards Phil

Hi Stefano, that file isn't intended for circulation as it was for illustration purposes but here it is. Regards Phil

LOL Anders. I have the same issues when switching between VBA, PHP and JavaScript.

The function to check for the length of a string is LEN, not LENGTH 🙂 regards Phil

Hi Ian, If you look at the source code for that page you'll find this bit for the State Code <select name="pv_state_code" class="form_data_...