ListBox Item Color

Visual Basic for Applications (VBA)

Index ‹ Microsoft ISV

- Previous
  - 1
    - Aproval of responses Hello, I registered four responses to crash events on September 26th. They're status remains "In Progress" (the tooltip says "Response is awaiting aproval") ever since. When can I expect the responses to be treated - T Tag: ListBox Item Color
  - 2
    - Inserting a row in VBA When I insert a row from Excel in my spreadsheet, the formulas (from the columns that have formulas) are copied from the prior row (with addresses properly changed) to the new row. When I insert an entire row from VBA, nothing is copied. Does anyone know what I need to do Thanks, KenCubs Tag: ListBox Item Color
  - 3
    - Need help in choosing the right function Hi I have to take required data from a sheet for say BOOK1.xls in sheet 1 and paste them into SheetA in Book2.xls There column A in SheetA contains is actually a list of 10 companies from column A in Sheet1, which has 100 companies I would like to copy and paste as values, corresponding cells in the same rows from Sheet1 for say, column G to column Z, to Sheet A is it possible to create a macro for that Looking for all the help that could be provided Sree Tag: ListBox Item Color
  - 4
    - Microsoft Office 2003 "word" not working properly after copying transferring hard-drive info via DiscWizard by Seagate Microsoft Office 2003 "word" not working prperly after copying transferring hard-drive info via DiscWizard by Seagate. I got a new SATA Seagate hard-drive and used their DiscWizard program to copy/transfer all the entire "OS" files. PROBLEM Windows Office 2003: when opening office 11 . . . the program trys to 'install' itself again and giving the message "source not found . . . run setup and repair. However the repairing is not working giving the following message: windows installer This patch package could not be opened. verify that the patch package exist and that you can access it, ot contact the application vendor to verify that this is a valid windows installer patch package. Does ayone have an idea on how to repair "WORD" microsoft office 2003 (all the other programs are working fine. Thanks! Note: I also had trouble with Adobe CS2 but after "re-registering / activating" online, all the programs worked fine. Note: I went to microsoft and the verified "again" the legality / validation of the microsoft products; but the "microsoft error" problem still shows. Tag: ListBox Item Color
  - 5
    - Counting words Does there exist a predefined function that counts the number of words in a string Tag: ListBox Item Color
  - 6
    - how to get the hyperlink value from an excel sheet cell hi All I have an excel sheet that have some cells with text and under the text there is a hyperlink to another files to the network driver Does any one knows how to extact the value of the hyperlink (not the text value that how up). I tried many variations like =CONCATENATE("link ",T(HYPERLINK(A1))) but it didnt help !! Thanks for participating Aws Tag: ListBox Item Color
  - 7
    - MDE from Access 2007 doesn't work? Hi There, I have created a small application in Access 2007, from which when I make an MDE (as the runtime for Access 2007 isn't yet available) the Access 2003 Runtime pops up an error saying that it was created in a newer version. Has anyone else experienced this Also, in an attempt to work around this, I created an MDB from 2007, which I then opened in 2003 and made an MDE which works fine, except every time I open the MDE that works, it pops up an input box (almost like a prompt, but nothing I designed) asking for an input value for TempVars!SwitchboardID. I have the MDE configured to open the switchboard automatically. I'm at a bit of a loss here, any chance that some of you have experienced this Many Thanks Tag: ListBox Item Color
  - 8
    - Communicator Mobile 2005 and TLS (Using port 4443 possible?) More options Confused on something with CM and CWA: We have web access enabled/installed, it uses MTLS and certificates on port 4443 to access the site... I'm assuming when using Communicator Mobile on Windows Mobile 2005, I specify TLS to connect remotely to the server (no vpn).. Is there a way to specify port 4443 or is the TLS port 443 even with Web Access installed on port 4443 (IE: these are different or the same) Thanks Tag: ListBox Item Color
  - 9
    - case insensitive VBA for excel Hi all, How can I make the below code case insensitive for the spelling of 'stat, Stat, STAT etc'. Any ideas how to make that happend 'ActiveSheet.Select For Each ws1 In Worksheets If ws1.Name = "STAT" Then Worksheets("STAT").Select If ws1.Name = "STAT" Then GoTo Start End If Next Thankful for help \Jonas Tag: ListBox Item Color
  - 10
    - Target Multiple Cells Hi I'm new to coding macros and have had great help with this forum in the past so thought I would give it a shot with another problem I have encountered. I have created a macro that looks like this (thanks to the help of Andy): Tag: ListBox Item Color
  - 11
    - Answer Error Report processing delay Hi, I've signed up for WER and done some of the important steps by now: 1. Obtained Verisign ID 2. Setup a proxy caching Symbol Store to hold our symbols and also cache the msdl ones. 3. Source indexing on all my binaries to automatically extract the correct source code from svn for the relevant crash dumps. 4. Mapped my products using the Product Feedback mapping tool. I've managed to get my application to not respond several times. The Fault report dialog popped up and I clicked Send which succeeded. I've also managed to get a crash to happen which I also sent. The Crash32 event has now shown up in WER, but there is still no sign of the hangs. My questions are: 1. Does an application hang also show up in WER 2. What is the turnaround from when the user clicks Send to when the event appears in WER Do you do a batch process every day Or less often 3. How does WER decide to only register a few details about the event, or to get a full minidump My crash only has a few details, and reports that it has requested a CAB. Thanks, Brian Tag: ListBox Item Color
  - 12
    - Using arrows to select in drop down list in access Hi - anyone know how to get a drop down list combo box to allow you to select an option using the up/down arrows on the keyboard in access rather than having to click on the down arrow on the combo box in access - user wants to do it by tabbing into boxes and using the arrows to select because its quicker. thanks, Rhys. Tag: ListBox Item Color
  - 13
    - WER and file version differentiation When mapping files against version numbers, does WER (and the watson servers) compare all four version_info fields For example, I have mapped version 4 of my application, for example, MyApp.exe, which has version 4.0.6192.0. As bug fixes are done for this application, the last integer gets bumped...now we are up to 4.0.6192.27. Do I need to remap the application, and/or upload a new mapping file for each bug fix Or will they all be mapped by the WER servers into the files uploaded for the ".0" versions thanks joel Tag: ListBox Item Color
  - 14
    - error message when closing ie7 The computer administrator profile is not having this problem only the other users on my home computer. Upon closing the browser this pops up: iexplore.exe Application error The exception unknown software exception (0x0eedfade) occured in the application at location 0x7c812a5b We have ie7. Can someone help Tag: ListBox Item Color
  - 15
    - Searching a directory for last two day's documents, return partial filename to bookmarks I need to search a directory with subfolders named by month, specifically, for the filenames of the last two created documents in the folder, referencing the current nonstandard date I specified in the activedocument. The date is bookmarked by day, month, and year values. I want to return only that nonstandard date value in the name of the file and put it in the bookmarks in the activedocument. Anyone got any ideas on how to automate a search of a directory like this to return the last day Reason being: Our document creation cycle is daily, but some days are skipped (holidays, weekends, days off, etc.) so I can't just do a Format = Calendar1.Value - 1, "dd" to return the previous day into the bookmark. Tag: ListBox Item Color
  - 16
    - Creating an ActiveX control in VB.Net for use in Access I am trying to create an ActiveX control in VB.Net 2005 that I can use on an Access 2003 form. My control a usercontrol with a picturebox control on it that I have extended. I have set the com visible attributes and registered the dll with regasm but it does not show up in the ActiveX control toolbox in Access. If I open the vba ide from Access it shows up under add references, but that doesn't help. Is this possible or not Tag: ListBox Item Color
- Next
  - 1
    - Word: How to you determine the current cursor position For one of my macros to run, I have to ensure that the cursor position is not in a table or in a frame when the user activates the macro. How can I find our the current cursor position Once I can determine that the cursor is positioned in a table or a frame, I can then code a message box to instruct the user where to put their cursor to run a certain routine. Tag: ListBox Item Color
  - 2
    - problem with mshflxgd.ocx in VBA Hi, I have a problem with the Microsoft Hierarchical FlexGrid Control 6.0 (SP4) on VBA. When I in desin a form, the system response me this dialog box: "the control could not be created because it is not properly licensed." How I can resolve my problem Tag: ListBox Item Color
  - 3
    - CRM 3.0 detecting logged on user. Hi, I am in the process of developing a callout assembly for CRM 3.0, part of this callout retrieves the user role of the currently logged on user. I have worked up the code that extracts user role of a given user GUID. My problem is that I am unable to get the GUID of the logged on user (this code is available in the SDK). This is my code for retrieving the user GUID WhoAmIRequest whoAmI = new WhoAmIRequest(); WhoAmIResponse Iam = (WhoAmIResponse)service.Execute(whoAmI); Guid userid = Iam.UserId; The problem with this code is that it is giving me the user under which the webservice object is created, which is always system unless I statically specify the webservice credentials in the dll. How can I get the user GUID of the logged on user Tag: ListBox Item Color
  - 4
    - Convert decimal string to Chr$() Hi. I'm currently writing a program for RFID using Visual Basic 6.0 But however I'm not sure how I can convert my decimal string to Chr$(). Because I currently wrote the code like this: Code Snippet decimal_string = CInt("&H" & hex_string) Char_String = Chr$(decimal_string) And an error pop up telling me that is an invalid procedure or arguement. Is there any code I have to add in between this follwing code Thanks for the help. Tag: ListBox Item Color
  - 5
    - Microsoft Office Document Imaging no longer in Printers Folder, Using XP and Office XP Professional This problem has been mentioned by many other users (in a different thread subject), so I wanted to start a new thread. I have tried many suggestions, but none have worked for me. My MODI has been a print option for me until just recently. It disappeared from my printers folder. I have repaired, removed, and re-installed Microsoft Office. The MODI will still not appear in the printers folder. Please Help! Tag: ListBox Item Color
  - 6
    - Automatic Sending of WER data Hello everyone, I was wondering if there was a way to automatically configure Windows to send generic or specific WER data to MSFT From a bunch of testing and research I did today (more details below), along with this post - http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1925302&SiteID=1 , I am guessing the answer might be no, short of doing the following -Implementing own crash handler or calling WER API -Having reports go to Corporate Error Reporting (CER) or with Vista ( AEM (Agentless Event Management) part of 'Operation Manager 2007'). I understand the privacy issues with WER data, however, it doesn't make a lot of sense to me at the moment why you would restrict this, if in the end, it's a conscience decision made by the Administrator. As a vendor shipping both binaries on the client side (our software would be one of many) as well as server side (our software would be the only non MSFT software on the box), we would like to recommend settings such that it allows easy collection of our vendor WER data w/ little user intervention (again, conscience policy decision made by end-user). This is important as there are huge misunderstandings and mistrust of what sending data to Microsoft actually entails. A huge percentage of users, and especially numerous IT folks, hate the dialogue, think it's annoying, almost always hit no, and don't understand that sending non MSFT data can help their vendor fix issues. Googling always seems to bring up articles for disabling it, second only to Vista's UAC This a huge education issue that ultimately, I think MSFT is responsible for, as it's poorly explained, and it seems Winqual knowledge is not very common. To prove my point, just think of the extremely rare times that submitting a report as ever gotten you something useful, even for MSFT software! That is changing a little with Vista, but it's a long road ahead, and I think MSFT could educate developers, IT folk, and end-users. In looking at, researching, and testing the WER settings (registry and group policy) across XP, 2003, Vista, I could not get crash data to automatically be sent to Microsoft. This is despite the Group Policy saying the following: <Snippet from Group Policy Editor - Display Error Notification> When Display Error Notification is not enabled, the user will not be given the choice of whether to report the error. If the Configure Error Reporting setting is enabled, the error will be automatically reported, but the user will not be notified that an error has occurred. Disabling this setting is useful for server machines that do not have interactive users. </Snippet from Group Policy Editor - Display Error Notification> This seems to be exactly what I want, but in testing, I never saw the TCP packets being sent to MSFT automatically. This did seem to put files when 'Configure Error Reporting' was enabled along with a Corporate upload file patch (CER), which seems to unfortunately confirm the post above. I guess by "automatically reported", they mean an event log and drwtsn entry, not submitted to Winqual Also, in reading about Microsoft Error Reporting (.NET or Office), it seems there is a setting to do this. "Send all queued reports silently Located in the Queued Reporting folder. Enabling this policy sends all queued error reports without prompting the user. If you also set the Local error reporting file path policy, reports are sent to a local file server. This policy is equivalent to setting the DWAllQueuesHeadless value entry to 1 ." Overall, I am hoping for a mechanism to automatically submit reports to MSFT by having the Admin change settings to do so. Resources: XP WER Settings - http://technet.microsoft.com/en-us/library/bb490841.aspx 2003 WER Settings - http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/ws03mngd/23_s3wer.mspx Microsoft Error Reportig - http://msdn2.microsoft.com/en-us/library/bb219076.aspx#MicrosoftErrorReporting_UsingMicrosoftErrorReportingonWindowsVista Office 2003 Reporting - http://office.microsoft.com/en-us/ork2003/HA011402421033.aspx Thanks, Ivan Tag: ListBox Item Color
  - 7
    - Windows Error Reporting - handling unanticipated errors For Vista certification, is any handling of unanticipated errors prohibited (other than throwing them) Let's say an application has to process a large number of files. If an unanticipated error occurs when processing one of those files, I wouldn't want that to prevent the application from processing the rest of them. Could we report the error through WER, but also handle it Tag: ListBox Item Color
  - 8
    - Save word document with images embedded inside the doc Hello: I have an HTML document which I am programmatically trying to save as a word document with all images embedded inside the doc. The following script doesn't seem to work... If I open the word doc, I see only a blank box where the images should be. If I uncomment the lines for unlinking, then the images show up OK but then I have to manually go into word to unlink the images and embed it into the doc. Any suggestions Thanks in advance! pvenkat ----------- OrigFile = WScript.Arguments(0) FinalFile = WScript.Arguments(1) Set wordApp = CreateObject("Word.Application") set wordDocs = wordApp.Documents Set wordDoc = wordDocs.Open(OrigFile) wordApp.Visible = False wordApp.Selection.WholeStory wordApp.Selection.Fields.Unlink wordDoc.SaveAs FinalFile, wdFormatDocument wordApp.Quit wdDoNotSaveChanges -------------- Tag: ListBox Item Color
  - 9
    - Any answers Yet? I have read through all the posts looking for the solution to this IEXPLORE.EXE Application error- Instruction at xxxxx referenced memory at 0x000000080,could not be written. So far does not seem anyone has a one size fits all answer. The post appealing to MS to put out a fix seems to be the most logical. I have tried disabling all the add-ons and it did not resolve the issue. Hope there is a solution soon, more an annoyance than anything. Tag: ListBox Item Color
  - 10
    - Combo Box Headache I have a combobox control embedded directly in a word document. I have added items as such: cboResults1.AddItem "text", 0 Why is it that when I put in the indexes, the control doesn't work Tag: ListBox Item Color
  - 11
    - Application.ScreenUpdating Problems I've been developing this really massive VBA Excel Application as part of a government contract and it's gotten to be about 55,000 lines of code, optimized down from more than double that of course. Everything seems to be working nearly perfect and I think I've even solved my problem with the call to Application.ScreenUpdating, but I'm not really sure why, and I couldn't find documentation relating to the problem I found or the work around that I developed. There are a number of things that I discovered. 1.) It seems that making a change to any cell on any sheet in VBA code will cause the application to change the users view to that sheet. This is the reason for the property Application.ScreenUpdating to even exist in the first place so that programmers can have control over what the user sees. 2.) Every time code execution enters a new module the property Application.ScreenUpdating seems to get re-set so setting any values to any sheets inside a module that the user isn't supposed to see whould set the property to false before making the changes to the sheet. 3.) If I run some calculations in a module and I need to update sheets based on the new calculated values then if I want to user to see the value in the cell change for the sheet the user is currently active on then I should set the property to True, then change the cell, then set it back to false before making additional changes on other sheets....My question is this: If in this case the code in the sub is executing from another sheet and I change the property to update the sheet the user is active on then will it cause a flicker because the code is executing on a different sheet For example: The user is working on Sheet1 and makes a change to some cell triggering a Sheet_Change. The Sheet_Change calls a sub/function on Sheet2. Sheet2 does some calculations and needs to update values on Sheet2 and Sheet1. Would setting the Application.ScreenUpdating Property in code from Sheet2 cause a flicker/ or visably active sheet to change to Sheet2 since the property change was executed from Sheet2 even if, inside the Property Set Block, i.e. between Application.ScreenUpdating = True and Application.ScreenUpdating = False the code is only accessing Sheet1. A similar case and more common would be to simply turn the property back to true at the end of the module since returning from the function means going back to code execution on Sheet1, in which case the user should see any additional changes. My experience is that the above example is true, but there is no documentation about this behavior at all! 4.) If you are in debug mode, and stepping through the code manually the property is ALWAYS set to true. This makes it nearly impossible to find flickering or other visible active sheet changes that the user would be annoyed by. 5.) I've read in a few places while doing research on this that some environments and versions of Excel reset the property at the beginning of every Macro which would fit with my experience, but again there was no documentation that I could find about this. Someone should probably update the documentation to reflect some of this more advanced behavior. Cheers Seth Tag: ListBox Item Color
  - 12
    - Help....Problem with browsing BSM 2005 with Pivot OWC12 from client side Help....Problem with browsing BSM 2005 with Pivot OWC12 from client side I have an issue when browsing Microsoft Business Scorecard Manager 2005 from another laptop, the PivotChart built with Microsoft Office Web Component version 12 can not connect to the Data Source, that is OLAP Cube built with Microsoft SQL Server 2005 Analysis Services. There is a warning sign in the OWC frame showing the error description: Failed to get data. If available, errors returned from the provider are listed below. - An error was encountered in the transport layer. - The peer prematurely closed the connection I already tried some attempts, but they did not help: The IE in client side already set : Enable Access Data Sources across domains in Security Settings The connection string from OWC to Data Source is: Provider=MSOLAP.3; Integrated Security=SSPI; Persist Security Info=True; Initial Catalog-KPI3_5;Data Source-mrgreen I tried to connect OWC from client to data source manually with the same connection string, but it could not see the cube. A role with appropriate permissions is created for the cube From the client side, I logged in with the Administrator user name which is used the same to create the data warehouse, build cube and build the scorecard On Server Side, in SQL Native Client Configuration, the TCP/IP is set Enabled Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider is already installed for the client side The address of the server side is added as Trusted side In the server side, in Registry, below HKEY_CLASSES_ROOT \ MSOLAP \ CLSID has the same value with HKEY_CLASSES_ROOT \ MSOLAP.3 \ CLSID Because Microsoft Business Scorecard Manager 2005 I use now is the 180 day trial, I am wondering if it is the reason causes the problem. Unless if there is any solution for this issue If is there anybody ever get through this problem, please give me a hint here. It would help me a lot. Thank you so much. Tag: ListBox Item Color
  - 13
    - Remove hyperlink underline from PowerPoint 2007 How do you remove an underline from a hyperlink in PowerPoint Everything that I have read says that you can simply click the underline button and it will remove it. This works in my Word 2007 but not in PowerPoint. Any suggestions would be nice. Tag: ListBox Item Color
  - 14
    - Listbox scroll problem Duuuuudes: I have a problem with scrolling to the bottom of a listbox in excel '03. I'm using the listbox control in vba, not the excel forms control. Anyway, when I scroll to the bottom of the list, it won't let me see the last item in the list box. It will stop one short and will actually have a space below the scroll bar that looks like it could scroll down one more list item but won't. I'm using the additem call to populate the listbox. I've tried recreating the listbox and it will work the first time it gets populated but seems like after repopulating it a couple times it will cause the problem. Can anyone shed some light on why this would be doing this Here's the code for populating the listbox: Code Snippet 'repopulate the lbdate listbox For i = 1 To wsfd.Range("FD_InProcDateData").Count TempDate = wsfd.Range("FD_InProcDateData").Cells(i).Value TempDay = Weekday(TempDate) Select Case TempDay 'sunday for facility x Case 1 With wsr.Range("R_Location") Worksheets("Report").lbdate.AddItem TempDate & " " & "V" End With 'monday thru friday for facility y Case 2 To 6 With wsr.Range("R_Location") Worksheets("Report").lbdate.AddItem TempDate & " " & "BC" End With 'saturday for facility z Case 7 With wsr.Range("R_Location") Worksheets("Report").lbdate.AddItem TempDate & " " & "D&D" End With End Select 'skip to next date Do i = i + 1 Loop Until wsfd.Range("FD_InProcDateData").Cells(i).Value <> TempDate Or i = wsfd.Range("FD_InProcDateData").Count 'if i equals the range count then exit the for statement. if this isn't done, the last schedule date will show twice. If i = wsfd.Range("FD_InProcDateData").Count Then Exit For End If 'backup a cell because of the next i statement i = i - 1 Next i Tag: ListBox Item Color
  - 15
    - Hello, I am trying to get a .csv file to open using the get open filename method! I want excel I am trying to get excel to open a .csv file using the get open file method. I want excel to open the file and read the data from the .csv file and put the data into an expense sheet. When I hard code the file using the open filename method, I am able to open the file and read the file to the expense sheet using a Do loop. I am using two counters to cycle through the .csv file and expense sheet. The i counter is reading the data from the .csv file and the j counter is reading through the expense sheet. I am using the Cells = Cells to place the data from the .csv file into the appropriate cells within the expense sheet.When I use the Get open file name method, excel would not read the .csv file and put the data into the expense.sheet . Here is an example of my code: Sub RunIt() Dim j As Integer Dim strFilename As String ' INSERT YOUR CSV FILE ON NEXT LINE strFilename = Application.GetOpenFilename 'When I type in this line of code, excel will not read the data from the .csv file 'Workbooks.Open Filename:="C:\test.csv" 'When I use this type of code excell will read the data j = 7 ' expense sheet counter i = 1 ' input file counter Do Until Cells(i, 1) = "" Sheets("Expense").Cells(j, 2) = Cells(i, 1) Sheets("Expense").Cells(j, 4) = Cells(i, 2) Sheets("Expense").Cells(j, 9) = Cells(i, 3) Sheets("Expense").Cells(j, 11) = Cells(i, 4) Sheets("Expense").Cells(j, 13) = Cells(i, 5) i = i + 1 j = j + 1 Loop Sheets("Expense").Activate End Sub Sub Clearit() Workbooks.Open Filename:="C:\test.csv" j = 7 ' expense sheet counter i = 1 ' input file (csv) counter Do Until Cells(i, 1) = "" Sheets("Expense").Cells(j, 2) = "" Sheets("Expense").Cells(j, 4) = "" Sheets("Expense").Cells(j, 9) = "" Sheets("Expense").Cells(j, 11) = "" Sheets("Expense").Cells(j, 13) = "" i = i + 1 j = j + 1 Loop Sheets("Expense").Activate End Sub ' NewFN = Application.GetOpenFilename(FileFilter:="Comma delimited Files (*.csv), *.xls", Title:="Please select a file") ' If NewFN = False Then ' ' They pressed Cancel ' MsgBox "Stopping because you did not select a file" ' Exit Sub ' Else 'End If Tag: ListBox Item Color
  - 16
    - Help needed with MsgBox Hi, I am trying to insert a quote and then a value from a cbo_box inside a msgbox, but keep getting a 'Run time 5' error. This is my vba script MsgBox "Please check selling price - Variance over 30%" + Str(MyForm.cbo_price.Value), vbOKOnly, vbExclamation, "INFORMATION" Tag: ListBox Item Color

Basha Sk

Hi All,

I am having two Listboxes. The ListBox1 is having some items and the ListBox2 is used to display the SubItems of the ListBox1 items. If i select two items in ListBox1 then these two items subItems will be dispalyed in ListBox2. So How can i differentiate these subItems with respect to their Parent items. Is it possible to set ForeColor to each item of a ListBox. Thanks in Advance.....

Basha

Top

Re: ListBox Item Color

Andy Pope

Hi,

The standard listbox control within VBA does not support multiple formatting. All items have the same format.

You could use a 2 column listbox for the subitems and include the parent text from listbox1 in either the first of second column. Or if you only want 1 column simply append the 2 texts.

You could try using the Listview control that comes with windows. This does have the ability to format each item.

Top

Re: ListBox Item Color

Basha Sk

Hi Andy,

Thanks for the reply. Do u have any sample for ListView control. Thanks in Advance.......

Regards,

Basha

Top

Re: ListBox Item Color

Andy Pope

http://www.dailydoseofexcel.com/archives/2006/12/26/listview/

One of many examples return via google.

Top

Re: ListBox Item Color

Basha Sk

HI Andy,

Thanks for the reply. It helps me a lot.

Regards,

Basha

Top