Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-09-2016, 08:00 AM
justphilip justphilip is offline Accessing Visual Basic on my 2010 copy of Excel Windows 10 Accessing Visual Basic on my 2010 copy of Excel Office 2010 32bit
Novice
Accessing Visual Basic on my 2010 copy of Excel
 
Join Date: Feb 2016
Posts: 5
justphilip is on a distinguished road
Default Accessing Visual Basic on my 2010 copy of Excel


I would like to know if Visual Basic can be accessed in my 2010 Excel. Is it an add on feature? My Excel does not have the navigation path described in instructions below. How do I get there? TIA JP

Source: http://www.spreadsheetml.com/finance...ckquotes.shtml

In Microsoft Excel 2007/2010/2013: Go to Developer->Visual Basic

2. Right click on VBAProject (your Excel Filename) and select Insert->Module. A default Module1 will be inserted. Click on Module1 and paste the VBA code below on the right hand side of the Visual Basic Editor. The following VBA code allows you to download data from Yahoo Finance using a specified Stock symbol, Start Date and End Date.
Reply With Quote
  #2  
Old 02-09-2016, 09:52 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Accessing Visual Basic on my 2010 copy of Excel Windows 7 64bit Accessing Visual Basic on my 2010 copy of Excel Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
right-click the empty part of a ribbon
Select Customize the ribbon
In the main Tabs section check the Developer tab
A new tab is now added with all you need


Hitting Alt+F11 should also open the editor
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 02-15-2016, 08:54 AM
justphilip justphilip is offline Accessing Visual Basic on my 2010 copy of Excel Windows 10 Accessing Visual Basic on my 2010 copy of Excel Office 2010 32bit
Novice
Accessing Visual Basic on my 2010 copy of Excel
 
Join Date: Feb 2016
Posts: 5
justphilip is on a distinguished road
Default Debuging Visual Basic within Excel usage

I was able to activate visual basic on my Excel ribbon but I ran into a code error - old coding example and apparent change in MSN format. Is there a debug feature that I can use? My coding background is dated but I was very good at it when active - 14 special languages. TIA JP
Reply With Quote
Reply

Tags
visual basic access

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to break Links to FIles in visual basic? Asinkan PowerPoint 0 11-15-2012 03:08 AM
Excel 2010 Visual Basic design/coding charlesmac Excel Programming 2 08-10-2012 01:13 AM
Visual Basic Editor changes from 2003 to 2007 Rockitman31 Word VBA 4 09-21-2011 12:01 PM
Referencing Tables in Visual Basic Editor DavidB Word Tables 0 09-21-2009 04:01 PM
Accessing Visual Basic on my 2010 copy of Excel A little Visual Basic Help Please leroytrolley Excel 4 08-22-2008 03:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft