how can i code for an Combo box please help me out

There is no 'popup' combobox like the Inputbox, however, we can program a userform to accomplish your request.

But I'm more interested in the process you're describing. Do you want to batch process the update, down Column A? Do you just want to update once? If the latter, then using ActiveCell.Value instead of Inputbox may be your solution.

We also may be able to accomplish this with a validation list.

Either way, userform, or validation list, we'll need a sample workbook WITH DATA that represents you're request.

see i have attached Sheet

whenever i run update module i need to enter the batch name tblprod_agr_001
because i have i have multiple batch names tblprod_agr_001,tblprod_agr_002,tblprod_agr_003

thats why i wanted to used combo box for selecting from multiple batches

whenever i run the update module should display a combo box for selecting particular batch name to be get updated

it is possible to do

Please help me out

Ok, so , you're sheet is empty. Do you have a list of batch names somewhere on a sheet?

Or is the batch names fixed at tblprod_agr_xxx and you need to pick a number of batch numbers?

This perhaps...

Please Login or Register  to view this content.

Does the batch file have an extension?

Does the batch name display correctly in the Immediate window?

Then, you'll have to change it so that it does, then duplicate that code to the dBASE command line. I'll be away from computer today and tomorrow.