I have created userform in my workbook but unsure how to
set it up to launch or show.
userform is called PlantForm.
in workbook Softscape .it has 14 sheets. each named by
area.
I would like the workbook to have a button or icon that
is tied to the userform.
what code do i use to have the userform be launched when
the button or icon is clicked? Or perhaps better to have
the form open up when the book is opened?? and clsed when
it is closed. the data to be sent to its cells??? on the
form i have a frame1 that consist of 4 labels and 3 combo
boxes. Do i put code in the frame module to launch
procedure to send data collected to the cells related?

is it possible for someone to show me a small , simple
example of what i am expalining here? been at this all
day and i have too much info in my mind to know which to
use. :)

Thanks kindly to anyone who helps,
mlm