Hi,
check Debra web have an excellent explanation and example

http://contextures.com/xlUserForm01.html

if this helps please click yes thanks

"Roy Gudgeon" wrote:

Hi

I have a 10 column database, I want to create a data entry form (via macro
command button if possible) but do not want to select every column. cna
specific columns be selected for the form and if so how ?
--
thanks
Roy