Answer Questions

• Magannahan Skjellifetti 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

• Ratheesh*MCP* Cells

  I'm really confused as to why I activate a cell: x = ActiveCell.Row Yet when I try to select that cell: Range (Cells(x, 1)).Select It comes up with an address way out of whack! What am I doing wrong Thanks for your reply. I think I figured out what is wrong, but I'm not sure how to fix it. The cell I am referring to has a number in it, P027812. The formula seems to be using that cell data as an address (coordinates) rather than just data. So when I try to select the range, it selects column "P" and row 27812. Any idea how I can fix this Hi Your code should work, I got an error when I ran it on my machine (probably my typo). I changed the syntax slightly and it works fine. The selected cell ...Show All

• Michael Maes Deleting Macro

  I want to delete the macro recorded in my excel file but the "delete" button is disabled. Is there another way to delete all macros thanks... Hi Your macros will have been recorded in a module. Right click the module and select remove module, say no to export unless you want to save the code to a file. ...Show All

• cssjm ADO Recordset CursorType Property

  I want to create an updateable recordset, whereby the values in a particular field in the recordset once opened are changed to something else if certain conditions are met. However, I do not want these updates to change the underlying datasource, otherwise I would be in trouble! I would therefore need to set the recordset's cursor type property prior to opening the recordset, of which there are 4 constant values: adOpenForwardOnly, adOpenKeyset, adOpenDynamic and adOpenStatic. I'm guessing the last one of these is the one I need, but can anyone confirm this is the case before I start Are there any other recordset properties I need to consider as well Cheers! Keith I've ressurected this thread ...Show All

• Milzit AutoExec will not execute properly

  Hello there I have an .dot file in the Word 2003 start-folder. When opening word, the file is read. The autoexec-macro should make a new entry with a number of commands and subcommands in the standard menubar. On about 300 PC's this works fine. On a few ones only part of the commands appear. All PC's run W2000 and Office 2003. Any idea regards Jurgen Ok, i've been working through the code to see what it actually was required to do. You mentioned that the entries menu_protection_set, menu_protection_clear and menu_archive are the only ones that appear within the custom Menubar. Well, those entries are the only ones (next to the "Formulare und Dokumente") who don't to have a IF .. ...Show All

• some1sxi Autofill

  Hello, below is a part of the code im using. I want this code to be flexible enough so that any range of data will work with it. Thus I want the autofill part to not be limited to N2:n1860. I may have data thats only N2:n100 or n2:n3000. Selection.AutoFill Destination:=Range("N2:N1860") Range("N2:N1860").Select Range("O2").Select Selection.AutoFill Destination:=Range("O2:O1860") Range("O2:O1860").Select Columns("O:O").Select Selection.Style = "Percent" Columns("N:N").Select Selection.NumberFormat = "$#,##0.00_);[Red]($#,##0.00)" Columns("N:N").EntireColumn.AutoFit Range("M:M,K:K,J:J,F:F").Select What code would I use to pop ...Show All

• ddawson04 Open PDF file

  Hi everybody, I'm creating a program in MS. Access but I just want to ask:, how to open *.pdf(extension) file in visual basic access (vba) thanks in advance. :-) Hi sweet-66, It's great that you got your answer but for the sake of others reading this thread in the future can you post the solution or a link. Hi sweet66 - sorry but ive been away for a while - yes that was exactly what my code did but it also allowed you to browse for the file and insert the path into datasheet view - a guy called Derek Smyth who is one of the fountains of knowledge on this forum helped me out with it - glad you got it sorted though. Rhys. I already got the answer to my q ...Show All

• MaHMouD 2006 Delete Unwanted rows based on value in cell

  Hi all, I have to loop through a range of rows with an excel sheet and delete unwanted data. To identify the rows to be deleted I have to do the following: Firstly I must start at A1 and check if it contains the value "Product", if not i go to the next row but if it does i must then delete this row and go to the next. I must then check that the next cell contains the value "Total", if not i go to the next row but if it does i must then delete this row and go to the next. I then need to delete each of the next rows until i find the next cell that contains the value "Product", delete this cell and then go through each of the next rows until i find the next cell that contains the value "Total&quo ...Show All

• dls104824 iexplore.exe - Application Error

  I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this Not sure if this is related, but I get a cannot read memory at location 0xXXXXXXX (varies) after I have 8-10 browser pages open, no matter what site I am at. I've learned to live with it, but sometimes, because of pop-ups, it still gets me. When it happens the mouse become slugggish and nothing it responsive. Then 6-8 minutes later, I get the error message. I've gone through several versions of IE and also several complete me ...Show All

• Simon Jefferies MSDN Licensing for a Microsoft Gold ISV Partner

  We are currently a Microsoft Gold ISV partner and I have a question as to how the licensing works for the disks that we get as part of our partnership. Specifically the difference between development licenses and internal use licenses. The partner program guide identifes the internal use licenses very well, but are there different licenses for development use or are the internal use licenses to total of what is allocated. The driving need behind the question is that in the MSDN packs we are sent we are given installs of all of the versions of for example SQL Server 2005. But in the partner guide is says we are allocated 2 SQL Server 2005 Enterprise edition licenses and 100 CALS. In this instance we do not need the software for internal ...Show All

• shimshon Live Communications Server tab does not show up

  I have just installed Live Communications Server 2005 Standard in my test enviroment. I have a seperate server as a Domain Controller (all servers are Virtual Servers on one physical machine). When I followed all the steps during installation, no errors show up. Also, the HTML log files only display green 'success' items. However, when I open the User Properties window on my DC, there is no Live Communications Server tab. It should show up there, but it isn't. Also, when I open the Live Communications Server Management Console, I only see an empty screen and no 'tree-view' of possibilities. When I manually add the snap in after running mmc, it works and I can see the Forest, Domain, etc. Nothing, except the Management Console, di ...Show All

• Tonnie 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

• Siol En Completly Lost with Data Validation Code

  I am trying to write a small script which will allow for multiple choices to be selected from a dropdown list, but for ONLY the dropdown list to accept input (ie data protection). I had asked for help before, and the nice people at Contextures sent me to their site to download one of their spreadsheets (dv0017 http://www.contextures.com/excelfiles.html). I have been looking at the code, and I am clearly in over my head. The code is below. Private Sub Worksheet_Change(ByVal Target As Range) Dim rngDV As Range Dim oldVal As String Dim newVal As String 'I think this means that if there is more than one cell selected, then exit If Target.Count > 1 Then GoTo exitHandler On Error Resume Next 'Absolutely no clue here. I have read a few di ...Show All

• Tanzir Ideas for storing results from multiselect listbox

  I need to store the results from listbox where the user may make multiple selections, any suggestions Hi Did not realise that you longer term storage, I was thing of short terms storage for VBA use. If possible us Access to store your data. Access can be used from any office app in VBA. You can also use an Excel sheet and use AODB to access it as a table; I am sure Derek Smyth replied to a post with an example of doing this in this forum. Hi I would use an array, which you can redim to fit the number of selected items, or if you are more adventurous try using a collection. The results will need to be stored in a table. ...Show All

• spshah Autocomplete entries in inputboxes

  I have some vba code that prompts the user of Excel spreadsheets for various data items needed to complete tasks on the particular spreadsheet. I have not been able to come up with a way of auto-completing the entries once enough characters are entered to make them unique based upon a range of data entries that I already have available. If anyone can help I would appreciate it. see previous answer Chas ...Show All