View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Chaplain Doug Chaplain Doug is offline
external usenet poster
 
Posts: 127
Default "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