Answer Questions

• Peter Holmdahl Referring to a range on another worksheet from within the worksheet module

  I cannot seem to get the range with cells to work from a worksheet module for a range on another worksheet. The following code gives me an "application-defined or object-defined error" on the If statement line. With Worksheets("ConceptData") If Range("NumTechLines") <> .Range(.Cells(iRowNumber, 10)) Then MsgBox .Range(.Cells(iRowNumber, 10)) End With When I replace the cells method with an absolute address "J6", I do not get ...Show All

• SkyPhy dbclick listbox additem

  Hello there, I have created two listboxes and wish to allow double clicking of items. i.e, double click on a partciular item in listbox1 will add the item into listbox2. i have tried various ways of going about to get it right but failed. Private Sub List1_DblClick() List2.AddItem List1.List(List1.ListIndex) End Sub can someone advise me or point out my mistake Thank you very much. Astrov You're code is ...Show All

• sakthiG overflow error 6

  hi i've got a problem with my vba code.. when certain data is input it creates an overflow error for no apparent reason. In this code, I have to calculate the number of days spent alive in each year, and the input includes the date of birth, the date on which the period of investigation starts, and the date on which the period of investigation closes or death occurs. The individualexposed() program deals with one life at a time: Sub Individua ...Show All

• Dundoan VBA eBook

  Apparently, there was a free eBook on VBA available a short while ago. Can someone point me where to download it Thanks, Antonio http://msdn.microsoft.com/archive/default.asp url=/archive/en-us/office97/html/web/FULLTOC.asp It's for Office 97 but still worthwhile reading if your using a newer version. Derek, That is very helpful. Thank you again. I could not find for ...Show All

• Albert Huang A Simple question about vba editor and vsto

  Is it possible that we write vba code in visual studio 2005 In addition, what are differences between vba and VSTO   Aside from exploring the site below, you might take a look at this article that details a VBA migration. http://msdn.microsoft.com/office/understanding/vsto/default.aspx pull=/library/en-us/odc_vsto2005_ta/html/officevstomigratingwordvbatovbnet.asp http://msdn.microsoft.com/office/understanding/vsto/defaul ...Show All

• Larry Joy Hyperlink to a subroutine

  Is it possible to get an hyperlink to run a subroutine I managed to get the hyperlink to go to the subroutine but it doesn't actually run it. It is possible to hyperlink to code from within MS Excel. Try this::: Open up your VBA editor and locate the "Microsoft Excel Objects" folder. Double click the SHEET object where the hyperlink is located. You should see an empty editor area with the words "Option Explicit ...Show All

• chantit about listview in vba excel

  hi... can anyone help me..... How to highlight an item in a listview using a textbox or how to search an item in a listview then automatically highlight the item if found It's me again Derek, Derek the commands work well with the listbox but i am using listview. I hope you will still answer me.. Thnx again FSV... Hello again, You'll want to loop over the items in the list until you find ...Show All

• PoInTeRkInG Business Scorecard Manager Test Server

  Hi all, (Firstly i hope this is the correct forum) I really hope someone can help mne with this as i'm at my wits end trying to figure out whats wrong. I have just set up a test server with Windows 2003 Server, SQL server 2005 and Business scorecard manager 2005 (All evaluation versions). Having read and followed the installation documentation everything seemed to install with no problem. The problem i am having now is that when i try t ...Show All

• adrian_sleigh Excell VBA: displaying values from the sheet in user form

  A simple question probably, but I got stuck on it. I have a user form that allows users to select and run some reports and what I'm trying to do is to put on that form a value from one of the sheets that will show the latest report date used. I tried with the text box and label on the form: Trx_Date = Sheets("Trx_Reg").Range("K1").Value Trx_Reg_Date.Caption = Trx_Date where "Trx_Reg_Date" is the text box ...Show All

• aninflal What is ISV

  Im sorry.. can somebody open that what ISV is sorry for that silly question : ) thank you > becouse Im from Turkey :( :-) OK, I can see that's a bit far. But, if Microsoft have the same ISV Community Days in Turkey, I think it would be worth the time to go along. The event today was informative and I'll certainly attend again. - Simon I take it as 'Independent Software Vendor". I work for myself. ...Show All

• Prasad.k. InlineShape.AddOLEObject method formatting wrong

  I'm trying to write a macro to embed OLE objects into word. I want the object to show up as an icon, ("display as icon option") but without any icon label. (The default behavior adds the file path as the icon label, and it does not matter whether or not the 'auto caption' option is enabled). It is easy enough to remove the text of the label itself, but the icon still retains the space for the label, such that the size of icon object is ...Show All

• RueSam compiler for VBA application?

  MY partner and I have a VBA application that runs as an Excel Add-in.  Is there a compiler that would allow us to distribute this (license even) without giving away the VBA source code Hi, There is no compiler but you can protect the project (Tools, VBAProject Properties). Hi! You can write a VB6 or Office Develper project and make a DLL. The VBA password is, hmm, I will not write down th ...Show All

• mohmsdn Can anyone download VS Team Edition?

  We are a Certified Partner with the ISV Competency. The ISV Competency gives us a license for Visual Studio 2005 Team Edition for Developers but, we can't download that or the Team Server from MSDN. We can download the evaluation editions but not the real thing. Is this a problem for all partners with the ISV Competency or just us Can anyone download the real editions of Team Foundation server and/or VS for Developers Thanks, John Vot ...Show All

• fprintf LCS

  My large company is looking at chatting applications, but isn't considering LCS.  Does anyone know if the LCS client is compatible with outside users on windows messanger.  I've used it once in, but i'm not sure if that was not available or just not in use.  I would really rather use LCS, but I think it will be a deal breaker if it won't allow others outside the domain to chat to users in the domain. ...Show All

• Amit Kumar Gupta unloading a function

  I have a question i am writing a program in Outlook. I have a button on a userform that when I click it I want to unload a function in a module from memory. I thought I could just put this in the click event: Unload Project1.Module_Name.Function_Name However, that just runs the function again. Also, I would like to know, is there any way in vba to say "unload all functions and subroutines" Anyone got any ideas thanks, Dudeman ...Show All