Forum

Hi Steve, That code isn't checking the value in the ComoboBox. Try this Private Sub Reg29_Change() If Me.Reg29.Value = "No" Then Me.Reg30.Text ...

Hi Robert, The code that you linked to on Excel Trick works fine so I can't do much to help you without your own workbook that you are having issue...

Hi Louise, In the workbook you download for the course there are 3 sheets of data : Sales Data New Sales Data Employee Data There are l...

Hi Steve, There's no workbook attached? regards Phil

Hi Sean, Your calling the sub FindLastCellAddy to find the next row to add data to? This sub is returning the address $F$11635 so I'm thinking tha...

Hi Jane, Can you supply your workbook please so we can see the data/tables. Regards Phil

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