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 cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by smma

  1. smma

    Build Range from array

    IDS and brengine, Thanks for your input, I do appreciate it. I got the code originally by Googling "Excel Tab Order" and found the post "Excel Tab Order - special request!" on experts-exchange.com. (Will I be banned for mentioning another forum?) Anyway, you can see the original code in its...
  2. smma

    Build Range from array

    Hello! I have a program embedded in an excel workbook that controls the taborder of a worksheet. The macro which controls the taborder is in the ThisWorkbook object, while the function telling the macro the order of the range is embedded in the Worksheet itself. The function began like this...
  3. smma

    Get username of open file

    Hello all! I have a macro which will search for a PDF in a directory and kill it if it exists. A problem occurs if someone else has the file open. I would like to have a msgbox pop up with the username who has the file open on our network, so the user can go and ask them to close it. Is there a...
  4. smma

    Progress Bar count lines of code

    So how do I update the control as each line is processed? That is what I am unsure of. I would like my Progress Bar (or TextBox) width to change for each line of code processed. What I don't know is how to read a line of code as a number and send it to the bar to change its width. Additionally...
  5. smma

    Progress Bar count lines of code

    Hello! I woud like to make a progress bar hack that uses the width of a textbox as the size of the bar. My question is how can I have the progress bar show while my macros are working in the background? Additionally, I would like the bar to increment for each line of code read, so the progress...
  6. smma

    VBA Combobox returns to top of code

    Clever! I hadn't realized that, but it makes sense now. About your recommmendation, I'm not exactly following you. What flag should I use to identify the change? Is there an example that I could look at that would show a similar condition? Thanks,
  7. smma

    VBA Combobox returns to top of code

    I have a combobox with the following code: Private Sub SN3_Change() cRng = 6 If Worksheets(1).Range("A6") <> "" Then CfgName = Worksheets(1).Range("A6") Else MsgBox "You must enter a Part Number before selecting a Paint Specification." SN3.Value = "~" Exit Sub End If If...
  8. smma

    Control Listbox &amp; Equation irregularity

    Okay, Joerd! I got it fixed. The vlookup formula has been changed to =VLOOKUP(VALUE(L6),D32:D55,3,FALSE). All of the values in the lookup except one are numbers, so they will be force-formatted by the addition of the VALUE() function which gives a proper return. To get the first value, which is...
  9. smma

    Control Listbox &amp; Equation irregularity

    But how is that possible? L6 gets its value from the combobox as the LinkedCell, which gets its values from D32:D55 as the ListFillRange. How can they not be exact? I even went back and changed the range & L6 to Text format, hoping to make it more specific. Is there any other problem? An options...
  10. smma

    Control Listbox &amp; Equation irregularity

    Sorry, Joerd...False gives me #N/A.
  11. smma

    Control Listbox &amp; Equation irregularity

    I have a control listbox in my XL spreadsheet. Its ListFillRange is D32:D55, and its LinkedCell is L6. The BoundColumn value is set to 0. In cell D6, I have a formula that retrieves the value which corresponds to the row that is selected in the listbox: =INDIRECT("F"&32+L6). This takes the index...
  12. smma

    Insert BOM API

    Good 2 know, I'll czech it out.
  13. smma

    Insert BOM API

    man, handleman, you're a genus:class:genius! (A little zoological humor there.) I didn't check the Constant Type Library; the only one that was showing was the 2005...since I have 2007, I thought it might have been obsolete or something like that. Well, that's what I get for those assumptions...
  14. smma

    Insert BOM API

    Okay, let me rescind my last post. When I start Visual Basic from SWX and run the code, it works peachy. However, when I copy the code to Visual Basic in Excel and run it, nothing happens; it cycles through the code and doesn't add the BOM in, but it doesn't return any kind of an error either. I...
  15. smma

    Insert BOM API

    handleman, interestingly enough, I did get it to work. My first problem was that the filename for the table template was wrong; that is, the path was correct, but the actual file was incorrect. It had two spaces in "HTC BOM" instead of one. I have since corrected. Secondly, and this is an...
See more

Part and Inventory Search

Back
Top