Recent content by logius

msinfo32 wasn't very helpful either. It didn't have much info about USB port assignment at all. ---------------------------------------- If you are reading this, then you have read too far... :-P

We've been having a similar problem with the same model machine ordered only two weeks ago. For some reason I keep getting the infamous blue-screen-of-death after about 4 minutes of being powered up. Although the issue seemed to be related to the video card, reinstalling the drivers had no...

Well, I've used the docking station for the Dell Precision laptop tons of times, and have never had an issue with powering up the machine after connecting it to the docking port. ---------------------------------------- If you are reading this, then you have read too far... :-P

Is there any way to find out which COMM ports are being assigned to USB devices? I'm trying to figure out which port my USB barcode scanner is using. So far the Device Manager hasn't been useful. ---------------------------------------- If you are reading this, then you have read too far... :-P

Oh, that's perfect, mrmovie. Thanks! ---------------------------------------- If you are reading this, then you have read too far... :-P

Anyone know of a method for checking if a particular worksheet name exists in a workbook. I know it'll probably use the Worksheets.Name property, but the actual code for searching is eluding me. ---------------------------------------- If you are reading this, then you have read too far... :-P

You need to put the code in the worksheet that you're using. From the VBA editor right click on the sheet you want to monitor and choose "View Code". Then, from the drop-down menu, select "Worksheet" and "SelectionChange". Swap out the test case with: If Target = ActiveSheet.Range("E12") Then...

The row I want to add in is sent to a seperate procedure via a variable value (RwIdx). Sub SrchResult(RwIdx As Integer) frmResults.lbxResult.AddItem (ActiveSheet.Rows(RwIdx)) End Sub SrchResult is called each time an item in the spreadsheet meets the criteria of the search. I've even...

ActiveWorkbook.Names.Add Name:="NamedRange", RefersToR1C1:= _ "='Full Data'!R2,'Full Data'!R4,'Full Data'!R6, _ 'Full Data'!R10,'Full Data'!R14,'Full Data'!R18, _ 'Full Data'!R21" Form2.ListBox1.RowSource = ActiveWorkbook.Names("NamedRange")...

The only problem is the RowSource will only allow a single range to be set. I tried using a disjointed NamedRange to simulate what I'll need, but it didn't work (although it didn't give an error the list remained blank). What I need is a routine to add in lines to the ListBox based on the...

There is no ListFillRange property for a UserForm ListBox. The RowSource is the closest thing. ---------------------------------------- If you are reading this, then you have read too far... :-P

Is it possible to insert groups of rows into a ListBox on a UserForm through VBA? The AddItem method doesn't seem be the right way to go for this. Any assistance would be greatly appreciated. ---------------------------------------- If you are reading this, then you have read too far... :-P

You could try looking into the Range.NumberFormat property. Maybe setting NumberFormat = "0.00" would give you the result you're looking for. Not sure if "0,00" would work the same. ---------------------------------------- If you are reading this, then you have read too far... :-P

The search would only run through about 80 or so cells, so I'm not too worried about speed here. That's an interesting alternative, however that may be useful in another piece of code. Thanks, Skip and PHV! ---------------------------------------- If you are reading this, then you have read...

Nevermind, just found the InStr function. It does the job nicely. ---------------------------------------- If you are reading this, then you have read too far... :-P