Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General PowerPoint Questions / March 2008

Tip: Looking for answers? Try searching our database.

Macro in Powerpoint/ced

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cedric - 14 Mar 2008 00:28 GMT
I have a macro in Microsoft Excel listed below.  I need to have it put in a
powerpoint presentation. How can I do it?   I need for each questions to be
on a different slide and for it to repeat until xxx is entered.  Any help
will be appreciated.

Sub OptionExplicit()
'
' OptionExplicit Macro
' Macro recorded 3/10/2008 by Student Financial Aid
'
Dim vName As String
Dim vAddress As String
Dim vCityStateZip As String
Dim vPhoneNumber As String
Dim vEmailAddress As String
Dim vRealEstateAgentAndCompany As String
Dim vxxx As String

vName = InputBox("Please type in your name?")
If vName = "xxx" Then
   Exit Sub
  Else
vAddress = InputBox("Please enter your address?")
vCityStateZip = InputBox("Please enter City, State and Zip?")
vPhoneNumber = InputBox("Please enter your Phone Number?")
vEmailAddress = InputBox("Please enter your Email Address?")
vRealEstateAgentAndCompany = InputBox("Please enter your Real Estate Agent
and Company?")
Worksheets("Sheet1").Range("B1") = vName
Worksheets("Sheet1").Range("B2") = vAddress
Worksheets("Sheet1").Range("B3") = vCityStateZip
Worksheets("Sheet1").Range("B4") = vPhoneNumber
Worksheets("Sheet1").Range("B5") = vEmailAddress
Worksheets("Sheet1").Range("B6") = vRealEstateAgentAndCompany

'
   Range("B1").Select
   Range("B2").Select
   Range("B3").Select
   Range("B4").Select
   Range("B5").Select
   Range("B6").Select

   
 vName = InputBox("Please type in your name?")
 vAddress = InputBox("Please enter your address?")
 vCityStateZip = InputBox("Please enter City, State and Zip?")
 vPhoneNumber = InputBox("Please enter your Phone Number?")
 vEmailAddress = InputBox("Please enter your Email Address?")
 vRealEstateAgentAndCompany = InputBox("Please enter your Real Estate Agent
and Company?")
 Worksheets("Sheet1").Range("B11") = vName
 Worksheets("Sheet1").Range("B12") = vAddress
 Worksheets("Sheet1").Range("B13") = vCityStateZip
 Worksheets("Sheet1").Range("B14") = vPhoneNumber
 Worksheets("Sheet1").Range("B15") = vEmailAddress
 Worksheets("Sheet1").Range("B16") = vRealEstateAgentAndCompany

'
   Range("B11").Select
   Range("B12").Select
   Range("B13").Select
   Range("B14").Select
   Range("B15").Select
   Range("B16").Select
   
   
   
   End If
   Application.Goto Reference:="OptionExplicit"
End Sub
John Wilson - 14 Mar 2008 09:11 GMT
Quick Check

Will the data be entered in edit mode or do you need to enter it "live"
during a presentation?
Signature

Amazing PPT Hints, Tips and Tutorials

http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk

> I have a macro in Microsoft Excel listed below.  I need to have it put in a
> powerpoint presentation. How can I do it?   I need for each questions to be
[quoted text clipped - 67 lines]
>     Application.Goto Reference:="OptionExplicit"
> End Sub
Cedric - 15 Mar 2008 01:31 GMT
I will enter it during a presentation.

> Quick Check
>
[quoted text clipped - 72 lines]
> >     Application.Goto Reference:="OptionExplicit"
> > End Sub
John Wilson - 14 Mar 2008 09:14 GMT
Does that macro work in Excel BTW?
Signature

Amazing PPT Hints, Tips and Tutorials

http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk

> I have a macro in Microsoft Excel listed below.  I need to have it put in a
> powerpoint presentation. How can I do it?   I need for each questions to be
[quoted text clipped - 67 lines]
>     Application.Goto Reference:="OptionExplicit"
> End Sub
Cedric - 15 Mar 2008 01:31 GMT
I had a problem getting to exit in Excel, but that has been solved.

> Does that macro work in Excel BTW?
>
[quoted text clipped - 69 lines]
> >     Application.Goto Reference:="OptionExplicit"
> > End Sub
Cedric - 18 Mar 2008 01:01 GMT
Any suggestion to my problem?

> Does that macro work in Excel BTW?
>
[quoted text clipped - 69 lines]
> >     Application.Goto Reference:="OptionExplicit"
> > End Sub
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.