Click Help On This Function My "Help" Doesn't Open
May 31, 2009Why when I click jelp on this function my "Help" doesn't open. opens only grey window....
View 3 Replies
ADVERTISEMENT
Bubble Chart Function - Click To Open Percentage By Subject Line
May 23, 2014I am new to excel and to the bubble chart function and need creating one for a presentation.
I was asked to do a bubble chart to show the open and click to open percentage by subject line
E.g.
Subject line: Win 20% open, 23 % Click to Open, Getaway 20$ Open, 21% CTO etc., to include an industry average for open and CTO in the chart.
X axis: click to open and Y axis: open
I tried the following in the picture and it doesn't look right.
Capture.JPG
Right Click Doesn't Work
May 19, 2008As said, the right click doesn't work anymore, last week it was working but it doesn't anymore. When I right-click wherever in the spreadsheet nothing happens but I know it's working because it works outside excel.
View 9 Replies View RelatedRight-click Menu Doesn't Exist
Aug 9, 2009I have few questions,
1. why the "auto sum" icon grey out, and doesn't work.
2. when I right click the sheet, the menu doesn't show up.
3. Insert columns/rows, When I highlight 2 columns/rows, right-click the mouse & the menu doesn't show up for me to choose insert col/row.
Click Event Fires But Doesn't Work Under Initialize Procedure
Jun 18, 2014Why this code DOES NOT work:
[Code].....
But this one DOES
[Code] .....
Why would a click event execute but the same code doesnt fire on a initialize event?
Workbook_Open Doesn't Run On Second Open
Dec 29, 2009I have noticed this on more than one workbook with an Workbook_Open macro. When you open Excel, open Workbook1, do some work , save or don't save and close, then reOpen Workbook1 without having closed the Excel application, the Workbook_Open macro in Workbook1 doesn't run.
Closing Excel and reopening Workbook1 initiates the Workbook_Open macro. It's as if Excel remembers having previously opened Workbook1 and so it doesn't rerun the Workbook_Open macro the next time you open it.
2007 Doesn't Want To Open WB Created In Code
May 17, 2007In my first workbook I select an area to copy/paste into a new wb with this code (from the board)
[Set source = Range("A55:K109").SpecialCells(xlCellTypeVisible)
Dim FName As String
Dim VBComp As VBComponent
Dim wbnew As Workbook
Dim x As String
Set wbnew = Workbooks.Add
Set dest1 = ActiveWorkbook
dest2.Activate
With ActiveWorkbook
FName = .Path & "code.txt"
If Dir(FName) "" Then
Kill FName
End If
For Each VBComp In .VBProject.VBComponents
If VBComp.Type vbext_ct_Document Then
VBComp.Export FName
wbnew.VBProject.VBComponents.Import FName
Kill FName
ElseIf VBComp.Name = "ThisWorkbook" Then
If VBComp.CodeModule.CountOfLines > 0 Then
wbnew.VBProject.VBComponents
The complete code in this workbook sends the entire workbook to one person and it creates a new workbook and pastes a range and the VB code needed to run the button it copies and sends this to another person.
The codes runs excellent in 2003. In 2007 I can get the entire workbook to send to the first person, but
The email to the second person will send, but they can not open the workbook. I get the error "File Format or file extension is not valid. Please verify file is not corrput and that extension matches file.
I know trust access to visual basic has to be enabled in 2003 for this code to run, so in 2007 I went to the Excel options trust center and clicked the box which says Trust access to the VBA project object model.
When I step through this code everything looks great. The worksheet area is correct, the button is copied, the code can be seen in the properties window, but then I get the email and it will not open.
There is even a line of code that kills the file after the mail is sent (temporary saving location is the desktop). So, I used a ' and made it a comment line so I could try to open the file from my desktop. It will not open there either. File extension being used is .xlsm
Open All Excel Files In Directory - Code Doesn't Work For One Specific Path
Feb 8, 2014I have my code here:
VB:
Sub openfiles()Dim Path As String
Dim ExcelFile As String
' Path = GetFolder("C:UsersKinteshDesktop")
Path = "C:UsersKinteshDesktopVBA programmingMaps"
ExcelFile = Dir(Path & "*.xls")
[Code] ....
NextCode:
GetFolder = sitem
Set fldr = Nothing
End Function
My problem is that the code all actually works (including the function and when I use the commented part), but pointing to this one specific directory (the one I'm using right now), literally nothing happens.
Open With Double-click
May 12, 2009I seem to have broken something!. Whenever I double-click to open an Excel file (.xls files are associated correctly), Excel opens, but nothing happens. That status bar says "Ready," but my workbook never appears.
If I do a File-> Open within Excel, then I am able to open the workbook. I have no idea what is going on. This occurs for all Excel files whether they contain macros or not.
IF Function Doesn't Work?
Apr 25, 2014i checked and checked and my IF function just gives me the wrong answer... attached is just a sample data..i have over 230 lines to check actually..
View 4 Replies View RelatedRemove Modules In Multiple Open Files Results In Error If Module Doesn't Exist
Jan 30, 2008I have a number of similar templates on a server used to produce quotations from other files with lookup formulas. They all have 2 modules, 3 & 4. Module 3 deletes certain data and shows values instead of formulas for most of the pricing etc. Module 4 contains a macro that logs info in another central workbook on the server.
If 2 files are opened based on the same template at once, when the Quote_Wrapup macro (in module3) is run on one of the open files(code follows) from a button on the spreadsheet it often produces a Run-time error '9' Subscript out of range error.
Sub Quote_Wrapup()
'To stop screen flicker
Application.ScreenUpdating = False
Range("D8:E9").ClearContents
Range("D8:F9").Interior.ColorIndex = xlNone
Range("qdata5").Font.ColorIndex = 2
Range("qdata6").Font.ColorIndex = 2
Range("A18:A1018").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
Columns("A:E") = Columns("A:E").Value
Range("A980") = Range("A980").Value...................
Open Directory Using Button Click VBA?
Apr 25, 2012I'he a button in Excel Userform and i want to open directory using button cliick and put selected directory in textbox1 e.g. i've selected D:Susheel then it will reflect in textbox1
View 3 Replies View RelatedOpen, Search, And Click Through Webpages.
Feb 26, 2007i found some code on chippearson's site to use excel to open a webpage, search for keywords, and click on the links... i'm see a couple different errors waiting for the webpages to load. the errors and code is listed below...
Errors
1. method 'busy' of object 'IWebBrowser2' failed
2. remote server machine is unavailable
Sub OpenLinks()
Dim o2
Set o2 = CreateObject("internetexplorer.application")
o2.Navigate "http://forums.slickdeals.net/forumdisplay.php?sduid=0&f=9" 'IE navigates to a webpage
o2.Visible = False 'hides IE
While o2.busy: DoEvents: Wend
Set o = o2.Document.All.tags("A")
M = o.Length: mySubmit = -1
For r = 0 To M - 1
If InStr(1, o.Item(r).innerhtml, "SD600", vbTextCompare) Then
o.Item(r).Focus
o.Item(r).Click: Exit For
End If
Next
End Sub
UserForm-trying To Open With A Button Click
Nov 8, 2002I have a User Form that I am trying to open with a button click. I made a copy of one workbook with a new name. The Buttons and Macros were all copied as well. I modified the old Userform so that I can release Version 2 of the Userform, and now when I click on the button in Excel, I get the following error : Object doesn't support this property or method. Run-Time error '438'.
The code assigned to that button is as follows:
Sub Button121_Click()
'
' Button121_Click Macro
' Macro recorded 8/11/2002 by Kale Mayfield
'
UserForm1.Show
End Sub
What am I doing wrong? HELP! Once you have the Userform populated with ComboBoxes,Textboxes, etc., is there now way of making changes to that Userform? If you make changes and rearrange the locations of the buttons and boxes and labels... does that mess up the button in Excel that opens the form to begin with?
Open An Application On Cell Click
Feb 23, 2009I tried to get a application to open but can't and I beleive its possible. since in another wb notepad is called.
To see if cell C10 is clicked to open application "GD&T_Font.exe"
Open PDF File On Cell Click
Jul 27, 2007I use Excel to track all purchase orders for my company. Is there a way to just click on the purchase order number in its cell and have it find and open the purchase order .pdf file that I have saved on the server. The file name is the same as the purchase order number. I do not want to use hyperlinks because there are over 11,000 files I would have to link to. I think it would be easier for me to just select the cell and have the information in the cell be the search name.
View 8 Replies View RelatedClick-able Link To Open Another Workbook
May 9, 2008I want to reference a cell from another workbook that is a hyperlink, but I want it to stay as a hyperlink and not text. Example would be workbook1 cell A1= workbook2 cell A5(which is a hyperlink) but in workbook1 A1 shows the text of the name of the hyperlink. I want the workbook1 cell to be exactly the same hyperlink...this way when I have multiple workbooks I just need to change the master workbook.
View 7 Replies View RelatedDir Function Doesn't Show Files?
Apr 17, 2013I am trying to write Excel VBA on Mac. Need to use the Dir function to get the file name in my document folder, but it showed only one file in the folder "DS_Store". There are actually several Excel files in the directory just don't show up by using this function. I have done some research on this "DS_Store" file, it seems a hidden/system file for Mac. It's fine, but it really doesn't make sense that other files won't show. Also, when writing VBA for Windows, *.xls refers to any file with a .xls extension. How to express the same thing for Mac? I am new with Mac, it just works so different than Windows.
View 9 Replies View RelatedAutomatically Click Yes When Security Alert Box Open?
May 28, 2013i need vba code to Automatically Click on "Yes" button. Actually i download excel file from website, it seems display security alert box before open the excel (ie:" Verify that the file is not corrupted and is from a trusted source before opening the file, Do you want to open the file now? "), i need a code to automatically click on "Yes" button in the Alert box.
View 4 Replies View RelatedUsing VBA To Open / Click In Or And Pull Info From Webpages?
Apr 2, 2014how to have VBA go in and type words in a field and click 'go', 'search', 'submit'.Vice Versa, If I open a web page (without VBA), How do I make it so that once that web pages opens, VBA is triggered to pull info from a text box on that web page?
View 2 Replies View RelatedCell Click Event Open The Form
Apr 23, 2008Is there a way that when a cell is clicked in a worksheet. that I can get a user form to open?
View 9 Replies View RelatedOn Click Method To Open The Find Facility
Nov 9, 2008I was wondering if possible i could use an on_click method to open the find facility in excel. I know it may be easier to use the Edit, Find or Ctrl+F way.
But i have people using excel with no past experience what so ever, and i would like to make it as easy as possible....i.e a click of a button that says "Search".
Close/Open Userforms On Mouse Click
Aug 23, 2006I have a menu structure in place so when a user clicks a button, it opens a Userform as a menu. The only problem i have is that if the user doesnt want to use that menu, and clicks on the spreadsheet, it doesnt dissapear.
Is there any VBA code that anyone knows that when a user clicks on the spreadsheet, or even just clicks their mouse anywhere (ie other menus at the top, spreadsheet, desktop) like a mouseout code on HTML so the menu will dissapear?
Open Message Box On Double Click In Cell
Mar 30, 2007I am trying to make it so that when you double-click in a cell in column A, a message box opens populated with the text string in the corresponding cell (same row) in column Z. Seems to me like it should be easy enough, but despite spending the last hour searching for clues, I can't seem to figure it out.
View 8 Replies View RelatedMatch Function Doesn't Find Values
Feb 5, 2009I've been using a Index and Match Functions to locate values,
What I'm trying to do is as follows:
Column A contains x values and Column B contains another value
A length is entered at the top of the worksheet, when the x value is greater than half the length the values will be mirrored about the centre point.
To do this i'm doing x-(length/2) to give the corresponding value of x on the other side of the length
I can do the If functions etc to sort all this out, but the match function isnt working, see attached, it isn't finding values which are in the list, when i use 0 for exact match, i've tried using 1 but it still isn't finding the correct values.
VBA Left Function Doesn't Work With Text?
Mar 23, 2012HTML Code:
If Left(Range("H18"), 7) = A23C567 Or Left(Range("H18"), 7) = A65C321 Then
ActiveSheet.Cells(6, 7).Value = "Business and Private Banking"
End If
Im trying top use the above bit of code and it does not work when the criteria is Text , so if I simply change the above to =1234567 it works fine -- But I need it to be alpha numeric
COUNTIF Doesn't Like HOUR Function Inside Of It
Jun 24, 2014The first three formulas give valid results but the fourth example throws in an error after hitting Enter. As you can see I put in the HOUR function. As far as my knowledge goes the HOUR function generates an integer.
So why does C4 not work? Formulas go in column C
A
B
C
1
22
20
1
=COUNTIF(A1,">"&B1)
[Code] ........
Min If Function Doesn't Work For Earliest Date Lookup
May 23, 2014I am having issues with a min if formula, even though i enter it as an array (ctrl +shift+enter), it only returns a zero.
The formula is supposed to return the earliest date from Raw data if the name of the company matches the one from the data validation ('Company lookup'!D3).
Dates are in column D and company name in column M
I checked, the dates are all formatted as dates
=MIN(IF(RAW!$M:$M,'Company lookup'!D3,RAW!$D:$D))
Match Function Doesn't Find BLANK Cells?
Oct 27, 2009I'm surprised and confused as to why =Match("",A1:A300,0) doesn't find blank cells in the "who does what" worksheet of the attached file.
View 2 Replies View RelatedTrim And Clean Function But Formula Doesn't Work?
Jan 31, 2014 I'm coping and pasting data (html) into a worksheet. When I try to format some of the columns as accounting$, number, ect. They won't format. It looks as if there are spaces before and after the data. So I tried the trim and clean function but it doesn't work, so I guess the blank "spaces" are not really spaces.
It gets better...
When I do the same exact copy and paste (as html) on another persons computer, they are able to format just fine, and the "spaces" are removed automatically.
Why is this working on one computer but not the other? Is it a setting that my computer has enabled or disabled? If so, what is it?
