View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Terry Tipsy Terry Tipsy is offline
external usenet poster
 
Posts: 37
Default How do I fill a cell in a user form from a selection on same form?

I'm new to creating user forms and I am working with a combo box sample form
I download from www.contextures.com (a great site I must add). I would like
to have data displayed on the same form once a user makes a selection from
the combo box. I.e. If the user selects account number '10-1000,' I would
like the description of this account, 'Petty-Cash' to display in the
adjoining field. This would just be a double check to make sure the desired
account was truly selected before adding data to my table. I'm sure I need a
look-up function, but I'm not sure how to tie the two together on the form.

Any help will be appreciated.

Thanks in advance.
--
T Tipsy