Answer Questions

• ZergaKilla Allowing the user to pick a cell in excel

  Hi, I would like to allow the user of my program to choose which cell that should be the starting cell for my program. How can I do this with a macro. This is how the code should work: It searches the worksheet for a specific text-string(This part have I fixed). If it fails to find that cell I want a pop up window to be visible where the user is asked to point out which cell that should be used as starting cell. The, by the user selected cell address should then be assign to a variable inside the code. Anyone that knows how to do this \Jonas Hi, I think giving you my utility file is more helpful. I am kind of too lazy to look into the whole thing. Basically this utility file give you all the example of some useful st ...Show All

• Samoyed Run Time Error 9 when Calling a Userform

  Hi folks, I am getting a run time error # 9 when I run a macro that calls a Userform or when I try to run code in a Userform module. The code performs beautifully on my computer, but it did not work on a coworker's computer. It ended up working on 3 out of the 5 computers I have tried it on. I have tried changing security settings to low, and a bunch of other stuff, but I cannot get the code to run on the computers that get the run time error on them when I try running the code on them. I get the run time error when I try to load or show any userform in the workbook and I get it if I try to run code that is in the userform module. However, if I paste the code into a regular module and run it, the code runs fine. Does anyone know what co ...Show All

• Euclidez How to capture Windows Menu Key in Excel (the right-click menu called via key press)

  Hello, I am trying to find a way to capture the event of a user pressing the Windows Menu Key in an Excel Worksheet. I have the right-click event captured on the worksheet, no problem. In that case, I display my own menu, rather than the "Cell" menu. But the user can still press the menu key and the default "Cell" menu will appear. I do not want to modify the cell menu, since I would like to work with both, my custom menu and the cell menu. I just want to control the display of the cell menu. Application.Onkey does not seem to offer a keycode for this key (e.g. such as {MENU}). Any ideas Many thanks... ...Show All

• X-Tatic Applying one cell's formatting to another cell

  I'm looking for a way to apply the formatting from one cell (i.e. range object) to another cell without using: sourceRange .Copy targetRange .PasteSpecial < options > Application.CutCopyMode = False The implicit selection of the targetRange is slowing down my macro, and making the sheet scroll unnecessarily. Note: I've already included the hack Application.ScreenUpdating = False, but this seems less than elegant, IMHO. rusty per our support engineer: I worked on the issue and got a sample code, on my machine it is working fine. There is no flickering or unnecessary scrolling of screen. Please pass this code to ISV and check if it solves his problem. Dim MyRang ...Show All

• Vladimir Dumchikov MS Office document and image writer print driver

  Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. A little bit different problem here. I was using this Microsoft Document Imaging Writer port (virtual printer) for quite some time to print what ever screen/file into a image file (mdi/tif format). This virtual printer was missing from the printer folder without I noticed ...Show All

• ivanchain worksheet_change and data validation

  Hi there I have an Excel spreadsheet in which one column has data validation set. So the cells in this column have drop-down lists with the pre-set allowed values. Now I want the cell in the neighboring column to be set to some default value when the user selects an item from the drop-down list. This seemed like it would be easy, using the Worksheet_Change event handler. When a cell in the first column is changed, it initiates a function which sets the value in the neighboring column to some default value: Target.Offset(0,1).Value = "default". The problem is that it doesn't work when using the drop-down list. If the user types in the value manually, or if a cell in the first column is deleted, it DOES fil ...Show All

• Exclude Summing up hours on form based on parameter query

  Hi there - im finalising my new activity system but i have one issue. on an activity form i have certain fields for information purposes that are non editable - they are 'hours worked with client' , 'hours worked this month' and 'hours worked for the day'. The first 2 fields are populated automatically by opening recordsets on form load or companyname exit and summing up the hours based on the relevant query where the criteria ensures that the query is already populated. However for the 'hours worked for the day' field the query is a parameter query (qrytodayhours) where activitydate = Forms![frmactivity]![activitydate] and i was then hoping to enter the following code to sum up the hours using a recordset on the on exit of the acti ...Show All

• smalamas List of ISV Resources

  Below is a list of resources every ISV should know:   1.        Tools & Support:   enroll to Empower to get access to relevant tools and support to help you develop your solution faster:   [ISV is required to become at least registered member in Microsoft Partner Program in order to participate]   2.        Product Specific Benefits: sign up your solution through the new innovate-on site to get more product specific benefits.   [ISV is required to become at least registered member (free) in Microsoft Partner Program in order to participate]   3.        Grow your Busines ...Show All

• nhaas Runtime Error '2001'

  I am using the following code to use an unbound text box to display the PM Name associated with the PM Number but for whatever reason, I keep getting the Runtime Error '2001' when I run the code. Private Sub Combo59_AfterUpdate() Dim StrName As String Dim strPM_Select As String strPM_Select = "[PM Number]=" & Me![Combo59] & "" StrName = DLookup("[Plan_Center_Name]", "Plan_Center_EPMC", strPM_Select) Me![PM Name] = StrName End Sub Please help. An explanation of the error would be great or if some one can tell me what it is that I am doing wrong that would be fabulous. Thanks! Hi Zac, I had hoped to get our internal support team to assist you with this question, but the offi ...Show All

• Daniel TIZON using dll file

  I have created a dll file using VB.net. And I want to use the function of the dll file in VBA. How can I do it Thank you Now, in my computer, there is an error when I run the function. "automation error , the system cannot find the file specified". Is there any way to solve it thank you Hi, Thank you very much. I follow the intruction you mentioned. It works fine in my computer. But an error occurs in other computer, file or assembly name or one of its dependencies was not found. since I use the serial port provided by vb.net, I would like to know which dll file I sould copy to the other computer. Thank you Hi ...Show All

• KarthikNarasimhan worksheet_change and data validation

  Hi there I have an Excel spreadsheet in which one column has data validation set. So the cells in this column have drop-down lists with the pre-set allowed values. Now I want the cell in the neighboring column to be set to some default value when the user selects an item from the drop-down list. This seemed like it would be easy, using the Worksheet_Change event handler. When a cell in the first column is changed, it initiates a function which sets the value in the neighboring column to some default value: Target.Offset(0,1).Value = "default". The problem is that it doesn't work when using the drop-down list. If the user types in the value manually, or if a cell in the first column is deleted, it DOES fil ...Show All

• Binumohan Mirosoft Certification for an Embedded Device

  Hello, I am currently working on a new custom device that will run an OS that was built using Platform Builder and a C# application. I would like to ask whether anyone knows what the guidelines are that need to be followed in order to receive Microsoft Certification for the device and application. Are there any documents that I can get that outline what needs to be followed in order to be able to get Microsoft Certification. Thanks, Rachad, check out the information at https://partner.microsoft.com/global/program/programoverview/certifiedpartner to see how to get Microsoft Certification. Good luck! The Microsoft ISV Buddy Team ...Show All

• benson81 Making changes to Access database table - via Recordsets or Update Queries?

  Hi, firstly, sorry if this is the wrong part of the forum for this question (things seem to have changed recently). My question is this: I am writing some VBA code to automate a job that I perform regularly, in MS Access. I need to carry out updates to data in an Access table, in a repetitive manner. The data needs to be put in a format that is mailable, I need to create fields like Age (from dob), Age Bandings, Gender (from title) etc. Before I knew any VBA, this was all done with Access Update queries and some lookup tables, but I never bothered writing a macro to speed this up. Now that I understand recordsets a little better, I've written some code to automate much of what I need to do, but to be honest, I dont know whether the V ...Show All

• ChrisMoje How to loop a macro every 20 minutes

  Hello, I need assistance with some code that will run this macro every 20 minutes in an Excel workbook that is constantly open. I think it needs to loop somehow but it is beyond my programming skills. If anyone can point me to the right Method I would greatly appreciate it!! Michael Thanks Derek ChasAA Nice one ChasAA. Hello Michael, Play around with the following and you should be able to get the result you need. ChasAA [Code starts] Sub start() ' Put this in your workbook open event Application.OnTime Now + TimeValue("00:00:15"), "runUpdate" ' I have set it for 15 seconds in this example change to "00:20:00" for 20 minutes End Sub S ...Show All

• humbroll Live Communicator TAB not shown

  I have the same problem with my AD. The LCS is installed on a AD server but the tab is not shown in user's properties tabs. I've already done all tests you did before but with the same result. Did anyone solve this problem thanks!! you should install lcs administrator tools--on the lcs installer cd. ...Show All