Forum

Hi Rafi, This code will go in the ThisWorkbook module of your workbook - see attached. Event code doesn't go in a 'normal' code module. R...

Hi Christopher, As Sunny said, the form in my blog post was designed to only search using one field and to return 1 record. How do you wish the ...

Hi Rafi, Use a Workbook_BeforeSave event Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) <<...

Hi Jenn, I've sent you an email. You could put the WB on Dropbox and link to it? Regards Phil

Jenn, Please supply your workbook. Regards Phil

Hi Sean, Just remove the reference to the sheet? =IF(INDEX(INPUTS!$H$4:$J$79,MATCH(F4,INPUTS!$H$4:$H$79,0),3)="""","""", INDEX(INPUTS!$H$4:$J$79...

Hi Sean, Please supply the workbook with the code/data. Regards Phil

Hi Sean, I don't really know what I am doing with this workbook. How exactly am I supposed to enter data into the Inventory Booked in Sheet? Usin...

Hi RS, Have you tried stepping through the code to see what it is doing? Debugging VBA Regards Phil

Hi Sean, Your VBA is password protected. Can't open it to debug it. Phil

Hi Steve, If there's nothing in the list you'll get this error. To check if there's nothing in the list you'll need to do something like If...

Hi Steve, Please supply your workbook and code. Too hard to debug without them. regards Phil

Hi Steven, It's always best to supply your workbook and code so we can see exactly what you are working with and give a better answer. Is the va...

Hi, Please see attached. The code for generating he email is taken from this post : VBA to create email and send with Outlook Regards Phil

Hi Lea, Insert (menu) -> Object -> Create from file (tab) -> Browse Insert an Object in Excel - Microsoft Regards Phil