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

Search results for query: *

  • Users: smma
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. smma

    Insert BOM API

    I am attempting to insert a Bill of Materials using a specific table template into a Solidworks drawing via API. My macro so far is thus: Sub Macro2() Dim BomTable As Object Dim BomFeat As Object Dim Names As Variant Dim Visible As Variant Set swApp =...
  7. smma

    Select All Checkboxes on Excel worksheet

    Hello! I have an Excel worksheet with 6 checkboxes on them. The first checkbox is supposed to check all checkboxes when it is clicked. I have the code below: Private Sub Checkbox0_Click() If CheckBox0.Value = True Then Dim i As Integer For i = 1 To 5 CheckBox(i).Value = True Next i End If...
  8. smma

    Insert/Edit a General Table via VBA

    I am writing a VBA macro that will populate a Solidworks General Table from a range of cells in Excel. What I would like to do is either edit an existing general table or insert a new one, via an If/Then statement. I can insert one with no problem, but I can't seem to edit/select an existing...
  9. smma

    Creating a simple array challenge!

    I am new to VB, and I have a question. I want to create an array from a range of cells, starting at C9 and using the xldown to go to the last nonblank cell to grab my array. Then, I would like to make the array be listed in two ways: if the number of cells is 1 (C9 only), it would only list C9...
  10. smma

    VBA adding notes to drawing from Excel

    Greetings! I am new to the forum, and would like a simple question answered. I would like to add notes in from an excel spreadhseet to my drawing template. Modifying the "Set New Note Example" from the Solidworks API help file, I have made the code below: '------------------------ Private Sub...

Part and Inventory Search

Back
Top