View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default How To Reference What Is In A ComboBox In A Cell Formulas???

=OFFSET(A1,0,5)

"Minitman" wrote:

Greetings,

I have a ComboBox on a sheet that I made from the Forms tool box.

If I choose an entry from the ComboBox drop down menu, how can a cell
formula use that data to find what is in a cell 5 columns away?

Any help will be most appreciated, thanks.

-Minitman