Forum

Hi Louise, Where did you get these 3 files? Have you actually downloaded the course files from the top of the course page? Regards Phil

Hi Henry, I answered this qs yesterday when you emailed us. Did you not get that reply? Use the CONVERT function and you can then format...

Hi Steve, I suspect that your VBA editor is already open. When you connect the 2nd screen, Windows just displays it on the newly connected screen....

Hi, You're using a Bulletin Board System? In Excel? Without seeing your workbook I can't really picture what it is you are trying to do. I don...

Steve, Your code? Phil

I have to ask, why have you got a shape covering the sheet? Phil

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