Hi every body.
I've written a code in VB with Excel.
In one Worksheet1 I'll have to input the details ie., thru Combobox an
option buttons. after this I'll click on a command butto
"GenerateReport", this will give me the finished report as per m
formating in a seperate Worksheet2. Any body tell me how to change th
details in the Worksheet1 to make it like the Dialog Boxes (windows)
shash

--
shashidharg
-----------------------------------------------------------------------
shashidharga's Profile: http://www.excelforum.com/member.php...fo&userid=1492
View this thread: http://www.excelforum.com/showthread.php?threadid=26673

I think you need to use a Userform in this case. As far as I know ther
is no way to convert wks to userfom automatically so need to make
userform like a wks1

--
Col

-----------------------------------------------------------------------
Colo's Profile: http://www.excelforum.com/member.php...nfo&userid=322
View this thread: http://www.excelforum.com/showthread.php?threadid=26673

Shashi,

Take a look at DataForm, it might help you.

--

HTH

RP

"shashidharga" wrote in message
...

Hi every body.
I've written a code in VB with Excel.
In one Worksheet1 I'll have to input the details ie., thru Combobox and
option buttons. after this I'll click on a command button
"GenerateReport", this will give me the finished report as per my
formating in a seperate Worksheet2. Any body tell me how to change the
details in the Worksheet1 to make it like the Dialog Boxes (windows).
shashi


--
shashidharga
------------------------------------------------------------------------
shashidharga's Profile:
http://www.excelforum.com/member.php...o&userid=14922
View this thread: http://www.excelforum.com/showthread...hreadid=266736