Execute from With Excel

[PCOR]

How does one execute a program from inside EXCEL
I have a spreadsheet that requires a number of date entries.
I also have a Visual basic program that displays a calendar. When you click
the required date, that date in place on the clipboard.
I know that I could use a tool bar but would much prefer to run the calendar
from a button on the spreadsheet. That way
it you remain with that spreadsheet
Thanks

 

[Chip Pearson]

The simplest way to do this is with the Shell command. E.g.,

Shell "C:\folder\file.exe", vbNormalFocus


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com