Drop list and recording a macro

hi everyone,

I am a complete beginner on this so please excuse me.

I have a form called input stock form and basically I am recording a Macro so that the information goes into stock data sheet automatically. This is all good but the problem occurs when I have created in my input stock form couple of drop down lists using the forms tool bar and selecting combo box. But I cannot record this as it come up with loads of boxes out of place in the stock data sheet,

how can i record information from a drop down list and produce it so that it is like all the otehr information without any dropdown selection and all in place..

Please can someone help me, thank you

Originally Posted by nish.patel

hi everyone,

I am a complete beginner on this so please excuse me.

I have a form called input stock form and basically I am recording a Macro so that the information goes into stock data sheet automatically. This is all good but the problem occurs when I have created in my input stock form couple of drop down lists using the forms tool bar and selecting combo box. But I cannot record this as it come up with loads of boxes out of place in the stock data sheet,

how can i record information from a drop down list and produce it so that it is like all the otehr information without any dropdown selection and all in place..

Please can someone help me, thank you

Hi,

It's difficult to understand the precise requirement/problem from the description you give. Could you zip up the workbook and attach it here, along with a few notes/examples of what you expect to do, and what you expect to see having done that, using the data in the workbook as examples.

Regards