Posts by trunfos

    Re: Print pdf file from Textbox link

    Option Explicit

    Private Declare PtrSafe Function apiShellExecute Lib "shell32.dll" Alias "ShellExecuteA" ( _
    ByVal hwnd As Long, _
    ByVal lpOperation As String, _
    ByVal lpFile As String, _
    ByVal lpParameters As String, _
    ByVal lpDirectory As String, _
    ByVal nShowCmd As Long) _
    As Long

    Public Sub PrintFile(ByVal strPathAndFilename As String)

    Call apiShellExecute(Application.hwnd, "print", strPathAndFilename, vbNullString, vbNullString, 0)

    End Sub

    Private Sub CommandButton1_Click()

    PrintFile TextBox1.Value

    End Sub

    I'm here with a small problem with the listbox.

    When I do search with the textbox will show the first line and I do not want to appear.

    this is the code i am using:

    Thank you for your attention.

    Re: Userform - Checkbox and Combobox

    I appreciate your help, it was spectacular.

    By chance know any example of a complete database?



    Re: Userform - I need to get right checkbox and combo box in this work

    Quote from mrmmickle1;772527

    You'll need to expand on what you mean. I've looked at your file and this does not make much sense to me. Can you please explain your issue in more detail?

    Thanks for answering.

    The ComboBox2 is not recording and the two checkbox are also not to recording to the database.

    I think it may have to do with it

    For a = 0 To 11
    Controls("textbox" & a + 1) = ListBox1.column(a)

    Summarizing need the combobox2 (Age) and checkbox2 and 3 to write to the database, at this time are not recording.
    After recording to the database, I need to pass the information to ListBox1.
    And then when you click on listbox1 need to pass the data to ComboBox2 and CheckBox2 and 3.

    I apologize for my English, I am Portuguese and I'm starting to use excel vba will very shortly, very thank you for your comprehension.


    Hi, i need help,

    I have a userform that only uses textbox

    i have this code:

    It works fine, but I now need to use the userform combobox, can someone help me, thx very much.