View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default Loading Excel Data into a Form

"Jim Rech" wrote ...

We use a form created in Excel to analyze property tax assessment


Userform textboxes (which I assume your using) do not have a property that
ties their values to particular worksheet cells, so, yes, you'll need a
macro to populate the userform.


By 'form' assumed the OP meant a formatted worksheet, in which case
there are many possibilities but worksheet functions such as VLOOKUP
are simplest.

Jamie.

--