Answer Questions

• Gert Jan Veenstra LBound and UBound functions

  Is there a reference library I need to enable in the VBE to get LBound and UBound functions They don't appear to exist in the Object Browser with the current reference libraries I have enabled. Many thanks! Keithyboy1 wrote: Andy Pope wrote: Hi, I believe those functions are in the Visual Basic for Applications library. Although not exposed via the object browser. Are you not able to use these functions I haven't tried using them yet, but since I could not find them in the object browser or help files, I assumed they resided in another .dll, which I would need to enable. Well, i've just searched through the VBA Help section and f ...Show All

• stang4lyfe protect,unprotect question help needed

  Hi, I need help with a excel file. I know very little about VBA. I have excel pro 2007 beta loaded. I would like to lock or protect all the sheets the workbook using vba. And still be able to add data to unprotected cells on one any worksheets. I need vba macro to do this so all the sheets are protected and run the macros but still be able to edit cells that are unprotected. The code below does not protect all the worksheets. Only the 1 st 2 out of 3. The two that are protected are where the macros run from. The third is not. If you need any answers to my questions. I can e-mail it so it can be reviewed. My code is below. Sincerely, Tom Robert Public K(7) Sub Pick6() ActiveSheet.Unprote ...Show All

• Chandresh Highlight Row depending on cell - Excel VBA -

  Hi All I need some help with this code ...... I have a sheet full of data, Col A , B & C full of data and col D is 1 or 0 ... I need to highlight all rows in red whenever there is a 0 in Col. D when i press a button (that i know how to create !) I don't want to use conditional format as the sheet slows down drastically using this method !! Thanks Hi I think this could be a shorter way to handle it. Sub highlight() dim cell as range Range(Range("d1"), Range("d1").End(xlDown)).Select For Each cell In Selection If cell = 1 Then cell.EntireRow.Interior.ColorIndex = 4 Next cell End Sub Hi, got my problem so ...Show All

• EjazAhmed Using Listview or Flexgrid Control in VBA

  Hi , Please provide some insight in using Listview or Flexgrid Control , as i am little bit stuck in coding. I am not able to find any property that allows adding item to listview or flexgrid. Thanks, Dongs Check out the recent thread in Dick Kusleika's Daily Dose of Excel blog: http://www.dailydoseofexcel.com/archives/2006/12/26/listview - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ ...Show All

• CTDATA Applying InsertBreak to a style?

  Hi, Using Word 2003 and not fluent in writing macros. I'm trying to write/string together a macro that would insert a page break in front of a style called H1 if H1 is on an even page. I've tried dozens of different pieces of code and can't get it to work. What I've tried is to find all occurences of H1 and when found, applied this: Selection.InsertBreak Type:=wdSectionBreakOddPage Unfortunately I'm not skilled enough to do this fully, and haven't been able to find any example macros that would do even something a little bit similar, so that I could modify that to my needs. Any suggestions/help you can provide will be much appreciated!!! Thanks, Laura Hi Navajo, Thank you very muc ...Show All

• sd_dracula Saving information in a form

  Hope someone can help! i have created a form in access where the user needs to input some information. What I want to do is be able to save this information on the form so that the next time I open the form the information is displayed, and also have the ability to change any field and save the changes. I also want to be able to save the information in an access table. Thanks a lot, I really appreciate any feedback/suggestions. HMariana Moved to VBA forum. Thanks for your response, it was very helpful :) Hi, I wrote a blog entry about how to do this http://dsmyth.blogspot.com/2006/05/saving-user-interface-state.html Generally what yo ...Show All

• stephanielauym How to generate a Desktop Alert programmaticaly

  Hi All, Sorry if I am asking a basic Question ,How can I can generate a desktop Alert Programmaticaly .I want to give a alert when ever a "Application_ItemSend" event is triggred. ...Show All

• clint 2 Userform Controls

  I have created a data request form for the company in Excel. The form has quite a lot going on (e.g. frames, option buttons, tick boxes etc). I've created all the necessary code and event handlers so that the form behaves as it should. In an attempt to record the user's input, I've then gone on and written a bit of code, which executes when the user clicks OK after completing the form. This bit of code loops through each control on the form and, depending on the control type, writes its caption or value to a blank spreadsheet. The issue I'm having is the order in which it loops through the controls. The tab order for the whole form, including that within frames, is spot on, yet this bit of code loops through some of the controls in ...Show All

• Nico_M need help with email attachement

  I need help whit the following code you find beneath. Everything works except the part of the attachment. So the mails are sended and so on but the attachement is never included. file in the code is just a string wi th the place of the file so c:\word.doc for exemple is in there. If you know how to solve the problem tell me plz. Im working in access btw. And te reference i use is Microsoft XML, v 5.0 Private Sub zendEmail() Dim sender, content, receiver, subject As String Dim XHttp As New XMLHTTP sender = " cijfers@dexia.be " subject = "cijfers suspens op " & Date content = " " receiver = " nbert@dexia.be ; prdou@dexia.be ;" ...Show All

• robertlamour Hybrid between Cells.Select and ActiveCell.CurrentRegion?

  Hello guys, Assume I have data like this. Each < > Means a cell. < > Means nothing in the cell. <A1><B1> < >< > < ><B3> If I use Cells.Select, the range will be ("A1: IV65536") too much selection. If I use ActiveCell.CurrentRegion, the range will be ("A1:B1") not enought selection. I wish to select the range ("A1:B3"). What should I do Thank you. Here's code that demonstrates how to do this. Option Explicit Public Sub DoSelect() Dim c1 As String, c2 As String With Sheet1 c1 = .Cells(1, 1) c2 = .Cells(2, 1) .Range(c1 & ":" & c2).Select End With End Sub It ...Show All

• Alba ado recordset problem

  i am using the following code and am getting the structure of customers structure returned to my application recordset rs - but there are no records being produced >>> what am i missing (the access table set is not empty) cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\lee\Northwind.mdb;Persist Security Info=False" cn.Open rs.Open "select * from customers", cn Hi, The following works for me in Excel. Include a reference to the ADO library if using early binding. Sub xx() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Set cn = New Connection cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\lee\Northwind.mdb;P ...Show All

• Behnam Fagih Unable to infopath form in browser

  ERROR: The form cannot be displayed in the browser because the use of session cookies has been disabled in the current browser settings. In order to load the form, session cookies must be allowed. Any pointers would be appreciated I have the exact same error when trying to connect to some Sharepoint 2007 infopath pages which are in the Local Intranet Zone. Path: WrkTaskIP.aspx ID=2&List=87365a5d-e84f-42fb-9244-28abe8dfbee9&_InfoPath_Sentinel=1 According to Microsoft all cookies are automatically accepted from Web sites in the Local Intranet zone. So why am I getting this error. I have changed my IE privacy setting to "always allow session cookies" but still get t ...Show All

• sakarmo Count the number of records that show up in a Access form

  I need to count the number of records that show up in a Microsoft access form. The forms record source is defined dynamically in vb using a select query. I need to know how to count the number of records that show up in a form. Open the results of your select query as a recordset. Then move to the last record in the recordset, and get the RecordSet.RecordCount property. Does this work How do I do that ...Show All

• ReevesEdward Stupid Question, how to turn Question Mark to Green Check?

  Sorry I post this stupid question here. Does anyone know how do I turn my question mark thread icon to the green check I can't find the option of doing that. Thanks. Hehe, NVM, the link for on icon has the answer. ...Show All

• Michael Vanhoutte Count and display in cell

  Ok I have an Excel workbook that contains a schedule (51 worksheets total). Each cell has intials in it and if that person has taken a day off the cell is highlighted a certain color (yellow, rose, or red). What I need to do is have something that goes through and counts what intials have what color and then display in a cell the number. So: If cell contains "initials" and cell color is "color" Then count and display in "cell" Example: If cell contains "JJ" and cell color is "Yellow" Then count and display in "A2" I know it is possible to do this but I'm not sure how. Tiger The count on the colored cells is great! That s ...Show All