Search results for query: *

I had been querying stock/financial data from Yahoo (non US) but it has recently upgraded its pages for that country to javascript and so now each page no longer has its own URL. I had been using simple VBA code to automatically get this data. Now I can only get the first page. When I hover over...

[Task]: I am trying to add some data from another workbook to this Summary by using vlookup on the name of company (which is hard-coded, not a formula). Simple, I've done this a million times, nothing is wrong with the formula. [Problem]: However, Vlookup is not returning the correct values...

I would like to name a particular cell in every worksheet "Sales" using VBA. Thus Sheet A would have A!Sales and Sheet B would have B!Sales. The following is a snippet of my very amateurish code. How can I code the RefersTo:= so that it is using variables instead of the hard coded cell address...

I would like to rename my worksheets depending on the presence of a word in a text-filled cell A1. Basically, my problem is that I do not know the syntax to find one element of many in one cell. Do I need to parse out X from the sentence contained in A1 first? Sub RenameSheet() Dim wkst as...

Is there a way to use VBA to automate the process of updating data labels (for a series not a data point) on an excel chart? I have a line chart graphing a time series. I also have horizontal lines for max, standard deviation, average, and min. These are labeled as such: max1.88x, 1sd1.36x...

I would like to have a command button on my excel worksheet be able to open up a Userform and jump right to a specific page(in this case, Page2) within a MultiPage. Is this possible or do I have to make a brand new Userform? Regards, Richard

I have a checkbox in my excel file. Depending on whether it is checked or not, I would like Cell A1 to grab value from either A2 or A3. e.g. Cell A1 = if(CheckBox1.Value = True,A2, A3) I do not know how to properly write the syntax for this. Thanks in advance! Richard

I have data that can be viewed as summary as well as continue to expand into more and more detail. As such, I would like to place a spinbutton on the worksheet that allows me to hide or unhide rows. I don't really know how a spinbutton works and the VBA help example is too high level for me at...

I am running a batch file, where I open up files which have 7 worksheets on average. I want to make changes on a particular sheet where in cell A1 contains the text "xxxxxx detailed". (where xxxxxx represents varying text). I would like my code to open up the file; search through Cell...

In my Userform I have several option buttons that represent "And" and "Or". These are for a customized search (Users can choose criteria X and/or criteria Y). After executing a search (by pressing a button), I would like to the user to be able to reset everything so that...

In the below code, I have the result from a combobox being compared to a range and if there is a match, to place the row number into another cell. I then convert this number into the name of a company. As I am continuously adding new companies to the list, I would like my program to become...

Currently, my comboBoxes and TextBoxes in Excel VBA userform start out blank. One must click on the arrows to see the choices. How can I have the boxes show a default choice? Thanks in advance, Richard

I have a MultiPage box, with four pages. One of the pages has alot more control boxes and I need more space, so I would like the page to automatically widen when clicking on the Page tab. Can one use if statements in the Private Sub MultiPage1_change? For instance, IF MultiPage.Page1.Select...

First, I must apologize for the code below, I am just starting out with VBA so I'm sure it will look very rudimentary to you all. I'm a financial analyst making a user-friendly dialog box that will help navigate through my database, which basically includes 130 companies. I would like my user...

I keep on getting a "cannot add anymore custom formats" in Excel as I have too many Custom Number formats (Format, Cells, Number, Custom). I would like to create a macro using vba that will hlep me delete all the custom numbers that I do not want. Thank you. I asked a simliar...

After consolidating various worksheets from different sources, I received a "Cannot add any more custom formats" dialog box. Looking at the styles (Format;Style), I see that there are literally hundreds of superfluous styles that I would like to delete. Is there a macro/VBA code out...