Collect Data On Excel Sheet Using Input Box

[Guido Geurs]

dear,

I'm sorry for the inconvenience but I have had no problems.(I'm using Office 2003).
Attached is a new version with some modifications on whitch I think could be giving an error on your PC, but I'm not sure it will be solved.

Do You know how to trace errors in VBA with a "Beakpoint" ?

PS:
When there are a lot of products in the list you don't have to scroll through the whole list ! => enter the first letter(s) in the top of the drop-down list and the list jumps to the first product in the list with the letter(s) you have entered.

br,

[nicolenwn]

dear,

I'm sorry for the inconvenience but I have had no problems.(I'm using Office 2003).
Attached is a new version with some modifications on whitch I think could be giving an error on your PC, but I'm not sure it will be solved.

Do You know how to trace errors in VBA with a "Beakpoint" ?

PS:
When there are a lot of products in the list you don't have to scroll through the whole list ! => enter the first letter(s) in the top of the drop-down list and the list jumps to the first product in the list with the letter(s) you have entered.

br,

Hi ggeu,

thanks a million for your help but it still seems like it is not working and still giving the same error. I am using Microsoft Excel 2002 (SP3). That might be the problem, although it was working fine previously. I will be trying this on another desktop that holds Microsoft Excel 2003 and see how it goes.

As for the breakpoint part, i'm not sure about it. I have been using Msgbox to solve my errors only(:

Thanks you again for your help ggeu!