thanks howard- I may have poorly communicated my intent -- the position can
vary (the vlookup is for performance metrics from another sheet)

I need it to fill B and C based on the value I input in the form (that
should match a position in column A)

"Howard31" wrote:

Do you mean you wantto be able to update Nmae and Rate based on the selection
of Position, with the corresponding values in the spreadsheet? If this is the
case why not use a Vlookup as follows:

TextBoxName.Text =
Application.Vlookup(ComboBoxPosition.Text,Range(Ce lls(1,1),Cells(50,3),2,False)

This should give you the Name of the corresponding Position
--
A. Ch. Eirinberg


"Memphus01" wrote:

I have created a form that allows me to enter names based on a source data
field.

Form uses combo box to allow me to ensure I do not mispell names (i have
vlookups tied to those names) and it allows me to enter a current rate (also
combo box with rowsource) and also a line for position.

I would like to be able to have that form control a value in a field, but
the field is variable. For example:

A B C

1 Position Name Rate
2 Cook
3 Cook
4 Front End
5 Front End
6 Front End
7 Front End
8 Front End
9 Clean Up

I would like for the form to enter the name I looked up and the salary I
input into the next available B,C column for the Position I enter for the
current page.

Is there a way to create a variable control source?