Posted to microsoft.public.excel.programming
|
|
"Switchboard" in Excel
Thank you Tom for your time and attention. God bless.
"Tom Ogilvy" wrote:
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.
http://j-walk.com/ss/excel/tips/tip84.htm
applicable to Excel 97 and later
Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp
--
Regards,
Tom Ogilvy
"Chaplain Doug" wrote in message
...
Dear Tom:
How would I set up this "user form"? Is this something I do in the VBA
behind an Excel sheet? As you can tell, I am not at the level you are. I
need more information and detail if you can give it. Thanks and God
bless.
"Tom Ogilvy" wrote:
You could put up a modeless userform
userform1.Show vbModeless
and have your buttons on that
If you don't need as elaborate of a layout, you could make a floating
toolbar.
--
Regards,
Tom Ogilvy
"Chaplain Doug" wrote in
message
...
Office Pro XP and 2003. I have written some VBA code in Outlook,
Excel,
etc.
that perform various functions. Is there a way to set up a
"switchboard"
type interface like that of Access that would call these various
macros
and
routines. At present I have some command buttons in an Excel workbook
that
do these things, but honestly it looks dorky. Any help would be
appreciated.
Thanks and God bless.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org
|