Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: logius
  • Content: Threads
  • Order by date
  1. logius

    Find out which COMM port USB is using?

    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
  2. logius

    Find if Worksheet Name exists in Active Workbook through VBA?

    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
  3. logius

    Inserting SpreadSheet rows into UserForm Listbox?

    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
  4. logius

    Parse a String with commas in VBA

    I know it's possible to parse a string in VBA using some built-in function using a specified delimiter (in this case a ","). Could anyone help with the code to do this? The goal is to take the string stored in a cell on an Excel spreadsheet and break it up for comparison against a user-input...
  5. logius

    Tie cells in multiple SpreadSheets together with VBA?

    Is it possible to tie cells across multiple spread sheets together so that VBA can reference them? In other words have Worksheets("Sheet1").Cells("A1") refer to Worksheets("Sheet2").Cells("E4") so that the two data values in the cells can be tied together later on using only VBA...
  6. logius

    Performing selective search?

    We have a UserForm where clients will search for items in an inventory based on multiple search fields. Depending on which data they supply (search criteria) the program will search for different data in the inventory. In other words: Enter Search Criteria: Serial #: 1234567 City...
  7. logius

    Setting ComboBox.RowSource through VBA

    There are two comboboxes: CityBox <- Contains names of various cities AddrBox <- Contains addresses of various locations Both are located on a userform but AddrBox is disabled until an item in CityBox is selected. Each is being populated via the RowSource object which is pulling data...
  8. logius

    Populate ComboBox with VBA

    In Excel there's a combobox that needs to be populated with data from a worksheet (A1->A24). A FOR loop seemed the most obvious way to do it, but when the code runs the compiler spits out an "Invalid Argument" error but doesn't highlight any specific piece of code. Dim MySheet as Worksheet Set...
  9. logius

    Validating TextBox input

    Here's the situation: there's a userform with multiple textboxes and one of them may have data that needs to be manipulated before it can be inserted into a worksheet. More specifically a serial number in the format of: X100001 X100002 X100003 etc.. Where "X" is a single letter that may...
  10. logius

    Creating a new menu item in EXCEL

    It's been some time since I've used VBA, but I do recall once creating a new drop-down menu in Excel using macros and adding in my own custom functions. The problem is I don't remember how I did it. Does anyone know how to accomplish this? I'm hoping to insert a menu after the "Help" item at...
  11. logius

    Share results of Access Query?

    Is it possible to dump the results of an Access 2000 query into an Excel 2000 document? If you can show me an example of pulling a few fields from an Access table then dumping the query into cell &quot;A1&quot; of a new Excel document and the results into the rows/columns (basically mimick the...
  12. logius

    Word Macro: Insert Leading Character

    I've created a word macro that will insert a character (`) at the beginning of each line in a newly created document. Problem I'm having is that the second line of the document isn't receiving the character. Here is the code in question: LoopVar = myRange.ComputeStatistics _...
  13. logius

    Excel: Test for blank lines

    Could someone help me come up with a method (VBA) for checking to see if there are blank lines between rows of data? Problem is that the number of rows can be variable. All I need to do is run down A1, and if there is a blank line between data, then delete the blank lines. Seems easy, but I...
  14. logius

    Help with Word 2K VBA

    Greetings all, I need some help with a routine I'm trying to write in Word 2000 VBA. What I need is code that will go through a newly created document and add a ` to the beginning of each line. I thought it would be easy but I'm trying to incorporate it into an existing routine. The main...
  15. logius

    Multicolumn Listbox, Possible??

    Hi there, may be a dumb question, but I've never worked with VBScript before. Is it possible to design a multicolumn listbox in VBScript to be populated with information from a database and displayed within a table on a webpage? It should be able to be sorted by any column when the user clicks...
  16. logius

    Which browers support which tags?

    Does anyone know of a place (website) to go where I can find a list of the tags and javascript functions that Netscape and IE 5 support? ---------------------------------------- If you are reading this, then you have read too far... :-P lightwarrior@hotmail.com
  17. logius

    Max length of characters?

    Does anyone know if IE (5.x and above) has a limit to the max length a line of javascript code can be? Thing is that I have a line of code that's being generated via a CF statement that's over 200 or so characters long in a single line, and I think this is causing an error in IE. Oddly, it...
  18. logius

    Max length

    Does anyone know if IE (5.x and above) has a limit to the max length a line of javascript code can be? Thing is that I have a line of code that's being generated via a CF statement that's over 200 or so characters long in a single line, and I think this is causing an error in IE...
  19. logius

    Hidden vars in IE 5?

    Might seem like a dumb question, but are there any issues with Internet Explorer 5.x and hidden variables used in javascript or coldfusion? ---------------------------------------- If you are reading this, then you have read too far... :-P lightwarrior@hotmail.com
  20. logius

    Methods of passing hidden variable?

    I'm trying to pass a variable from one form to another in a webpage using javascript with CF. Problem is that the hidden variable I'm passing isn't being received by the other page (it works in Netscape but not IE). Are there any other ways I can go about passing a variable that I want to keep...

Part and Inventory Search

Back
Top