ListBox issue

I placed a ListBox control on a spreadsheet and, for some reason, am having a 
great deal of trouble with it.  The majority of the time, nothing happens 
when I click it - the scrollbar won't work and I can't select anything.  
Sometimes, if I turn Design Mode on, then off, it will start working, but not 
always.  The sheet it's on is not protected.  I've tried it with the control 
locked and not locked and it doesn't seem to make a difference.  What have I 
done wrong?
0
Utf
12/7/2009 8:02:01 PM
excel.programming 6508 articles. 2 followers. Follow

0 Replies
862 Views

Similar Articles

[PageSpeed] 35

Reply:

Similar Artilces:

routing issue #2
we have two routers, one is attached to an ISA server which is used mainly for the internet one is attached to the exchange server which is used solely for email the exchange server is sending mail throo the ISA router server - how can i make it use the exchange router ? - the IP of the ISA router is showing in the email headers mark Hi, I presume the default gateway of the Exchange server is the ISA router? Therefore it will always route through it. This is all theory, as I haven't got the time to test it at the moment: Add another IP to your Exchange server, which DFG is the r...

CRM 3 Post-callout issues
Hi guys I am having a bit of trouble getting a post-callout working for v3 of CRM, I have found that compared to the documentation for the CRM 1.2 SDK documentation, the docs for 3.0 are quite lacking. I have written and compiled my callout and I have registered it on the CRM server inline with the documentation and this error appears in the event log of the server when I try to access the object which has been configured to use the callout. --------8<--------- Error: ISV code threw exception: assembly: XXXXCrmCalloutV3.dll; class: XXXX.Crm.Callout; entity: account, event: postcreate, exc...

Email Issues
Just got Windows 7 on a new computer and decided to try the live mail. Having trouble since day one! I have been intermittenly able to send or receive email -- more often I can't. Sometimes I get an error message that says my virus software may be the cause. Called the virus people - they said to uninstall and reinstall virus software, it may have been due to an update. Tried that. Sometimes it says server response is the problem. Can someone tell me how to fix this? LIz schrieb: > Just got Windows 7 on a new computer and decided to try the live mail. > Havin...

Mail import issues.
I recently set up my windows mail so I could send email through other programs on my computer. During setup, I chose the option to NOT import all of my emails from my outside email, but the first time I send an email through windows mail, it imported the emails any way. I checked my online email account and it removed all of my email. I need to be able to access my email from various computers, so I need my mail back into my online account. Anybody know how to do this? Thanks WinMail didn't import all your mail, it downloaded it from the server. The only way to get it ba...

SQL Server Issues Error# -2147467259
I have 1 machine on our network is running Win 98 to accomadate our printer/copier. The rest are XP Pro. We had a problem where the network locked up and had to reboot to get up and running again. But now I cannot connect the Win 98 machine to the database through administrator. I have tried uninstalling and re- installing RMs to no avail. The error I receive in the admin is: Error# -2147467259 [DBNETLIB][CONNECTIONOPEN (CONNECT())] SQL Server Does Not Exist or Access Denied. Help. I don't know if it will fix your problem, but have you tried typing the IP address of the SQL server w...

X-Y map of 2 issues with one PIN
I want to map on an x-y chart two issues about 2 to 4 products I want to map the products by 1) there price & 2) there complexity I built the data and the chart but my problem is that I am getting 2 sets of plotted pins - one set is how you would expect in various points on the chart the problem is that there is a second set of plot points that run acroos the bottm of the chart and if you remove that plot range from the chart then the other polt points are no longer dynamic. This use to be easy You need to share some more about what you are doing. What are you plotting? Price...

Number/Text Formatting Issue
I have a Workbook "Case Prep File" that pulls information from another workbook "Client List". I have written a macro (fired by commandbutton on "Case Prep File") that opens an input box to enter a client number and then compares that information to numbers in Column A on "Client List" to pull the client information from the corresponding rows. I am testing the code in step mode in VBEditor and I see that the number entered into the input box "GIDInput" is the same number as the value for ....range("groupid"), except &...

shared calendar/printing issues
Hi, I'm new on this forum, but seems to be a very nice folks aroun here! here's the situation I have. there's this manager who shared her calendar with her admin, her admi is able to access the calendar (the manager gave her owner' permissions), so, she's able to access it, to accept, decline, etc etc, the funny thing is that when the admin tries to print he manager's calendar, it works fine on a month view, and on a week view but when she tries to print on a day view, Outlook returns an erro message "the program interface returned an unknown error, close th app...

Stock count item/site issue
I am starting stock counts and I have come accross a particular 'group' of items that tell me "this item/site combination is listed in another stock count that is in progress". In checking into my started stock counts I do not find these items. How do i correct this so I can start a stock count on these items? Thanks -- Paula ...

Issue with CSV file
I am programmatically creating a CSV file that has a list of formulae from a workbook/worksheet (see example below). Note that there are 5 records in the file, tho the text might wrap below in your newsreader to appear to have more lines. Double clicking on the CSV file causes Excel to issue #NAME? errors for the records marked as BAD, The records marked as "BAD" cause Excel to try to update the text due to the included references to worksheets. This occurs for a formula that begin with a "-" character. And, ditto for a "+". I can avoid the problem by sticking an...

Outlook 2007 & Instant Search Issues
I was hoping to get some clarification on this issue. We are running Outlook 2007 on Windows XP SP3. When we moved from Outlook 2003 to 2007 we noticed a change in how Outlook searches for email. We are also using cache mode now as well with 2007, not with 2003. Basically, you can’t use wildcards in Windows Search, and any search acts as if there is a “*” wildcard at the right edge of the search term, but not at the left edge. For example, , searching for “vand” will bring up emails with “Dave Vandertie” in the “From:” field, but miss emails with “dvandertie@ridgedx.com” in th...

Design issue about which class a method should belong to
Hello! We have the two classes Person and Elevator. I just wonder method NewFloorRequest that set the floor that the elevator should go to which class should it belong to between Person and Elevator. I mean if I put it in class Elevator we can pass the floor that we want to go to as a parameter. Class Elevator has information about how many floor the elevator has which mean the method can check if the passed floor for NewFloorRequest is valid. On the other hand if I put it in class Person which doesn't seem right but if I still put it in class Person we can return the ...

MS-CRM Workflow Manager/Monitor issue.
I have installed successfully the MS-CRM 1.2 application on a windows 2003 server. Even if I am logged on as the administrator of this windows server, when I attempt to invoke the workflow manager or the workflow monitor, I get the message "You do not have sufficient Microsoft CRM privileges to run the Workflow Manager. For more information, contact your system administrator". I have been looking everywhere for information as to why I do not have the necessary privileges, I cannot find it. According to the documentation I do have the proper licensing setting. If anyone kno...

HELP! CAN RECEIVE BUT NOT SEND EMAILS! On going issue!
I hope someone in the community can help because this issue is really annoying. There doesn't seem to be any help for it online. When I try to send an email the below message comes up (please do not suggest checking the authentication setting as I have tried almost anything to get it to work). Thank you to anyone that can help! The message could not be sent. The authentication setting might not be correct for your outgoing e-mail [SMTP] server. For help solving this problem, go to Help, search for "Troubleshoot Windows Mail", and read the "I'm havi...

Multi currency issue isolated problem
Hi everybody - I have this problem in one company only - when I go to financial/setup/multicurrency - it shows buy/sell/average [this is good] but then when I go to financial/setup/rate type and select the exchange table ID it only shows buy/sell -where is the average? how do i get it in there? I tried to fix it in financial /setup/multicurrency but like I said before its already there. I also tried to delete it withing financial/setup/multicurrency and then recreate it - but it wont let me do that either. Help! Make sure the company has access to the exchange table. Go to Tools>...

Removing empty rows issue Please Help!
Hi Everyone, I have about 10 different tabs in same format in my workbook and having some difficulties with my macro. Basically, My macro runs through column("B:B") and if the cell is empty it will remove entire row, if not then it returns column D's value with matching row. Sub Clean() Dim ws As Worksheet, lngRow As Long For Each ws In Sheets For lngRow = ws.Cells(Rows.Count, "B").End(xlUp).Row To 1 Step -1 If ws.Range("B" & lngRow) = "" Then ws.Rows(lngRow).Delete Else ws.Range("D" ...

Roll Up and Revalue Issue
We have some items pending mateiral costs entered in the standard item material costs window. After we ran rollup and revalue, those pending material costs entered cannot be updated. When we checked the Item Pending Cost Revaluation Report, those pending material costs entered show 0 and current costs also show 0. Even we have tried deleting the Pending Std Costs for them and entering them with a different date, they still cannot rollup and revalue. We found 25 items currently cannot rollup and revalue. Please help. Thanks A few thoughts......Are you certian that these items have a ...

Public Folder Access Issues
Here is a wierd one. (Please do not referance the article "Removing the first exchnage server in your Org" been there, done that) I have rehomed all public folders to NEW server. Unmount Public Folder store on OLD server. Outlook 2002 clients can no longer access Public Folders. Outlook 2003 clients can access Public Folders, no problem. I upgraded a non working 2002 client to 2003, and boom, there are fixed. What is the differance? What is the setting on the client that needs to be updated to find the Public Folders on the new server? Definalty looks like a client and no...

ListBox on Worksheet AddItem
Will very much appreciate it if someone can tell my what I have got wrong in the example code. I have searched unsuccessfully for the answer. See comment in code where following error is returned. Runtime error 438 - Object doesn't support this property or method. I want to add an ActiveX ListBox with MultiSelect to a Worksheet and then populate it with AddItem. Private Sub CommandButton2_Click() Dim lListBox As Long Dim tListBox As Long Dim hListBox As Long Dim wListBox As Long Dim lstBox As OLEObject With ActiveSheet lListBox = .Cells(2, 2).Left tListBox = .Ce...

Design issue; and finding and displaying row on other workbook
1. An academic course is divided into two sections: lecture and discussion. The lecture section contains all classes, but the discussion classes do not. The discussion section is further divided into three subsections, each containing multiple classes. The need is to coordinate student attendance and grades for all sections. Currently we have 1 lecture section workbook with all student names, IDs, and other info; and 3 discussion section workbooks with the same only for the relevant subsection. And then there is a consolidation workbook where lecture and discussion are put together and attend...

MS POS (Not RMS) Lockup Issue
We are using MS POS and frequently experience a system lockup in the midst of entering a sales transaction. The cursor displays the hourglass, the base taskbar identifying the employee logged in disappears, and Task Manager indicates POS is not responding. This behavior cannot be duplicated or anticipated, it happens inexplicably and at the worst possible moment, and the only resolution we have found is to kill the app and hard boot the machine (Casio QT8000); attempting to soft boot or restart POS produces an application message indicating the MCR (magnetic card reader) is not respo...

Xml // Reading Element Value // Namespace issue // XPathExpression XmlNamespaceManager
Ok, my xml inability shows itself once again. Thanks for any help. Below I have some xml and some code for trying to get the "Publish_Date" element value. I've tried 4 different ways to get it. (If you uncomment the lines in the code seen here, you can see the ways I've tried to get the value) theOneImGonnaTry = myNameSpaceNameLocalName1 + ":"; theOneImGonnaTry = myNameSpaceNameLocalName2 + ":"; theOneImGonnaTry = myNameSpaceNameLocalName3 + ":"; theOneImGonnaTry = string.Empty; (The code seen above makes more sense when you look at th...

Excel PC vs. Mac issue
We have a bunch of Mac excel files (Office 98 Mac) which when printed fill the page left to right (invoice type), when opened on a PC (Office 2K) the print seems narrow. re the form stops 3-4 inches from the edge of the page (right hand side)as opposed to the 1 inch border experienced on the Mac printed page. Printer is HP5si both printing through the same cue using the same drivers. Looking for ideas as to why... thx Well, sometimes Windows is like that...kinda narrow and comes up a little short. This sometimes happens when a font on one platform is not available on the other, and ...

Microsoft Update issues
the last automatic update restricted the access of network computers (users)to company internal website, printers, but not information on the server. User templates are "x" out with red x Any ideas how to remedy? Regards and thanks in advance We need a lot more info. What are the exact symptoms when access to network resources fails? Have you restarted the server since installing the updates? Any errors or warnings in the system or application logs on the server or workstations? Can you ping the server from the workstations and the workstations from the s...

Transfer Out Serial Number Issue
I'm working on setting up RMS for a store. We have many items with serial numbers that we wish to be able to track. We sell many of the items retail but also use them internally to build assemblies that we sell. I have the database set up with the items and have serial numbers entered for the items. We are trying to use Inventory Transfer Out to take the serial items out of inventory for our assemblies and then Transfer In the completed assemblies. I am seeing a problem with the serial numbers when issuing and committing the items. Transfer Out doen't appear to check the...