Posts by Bendfella

    Thanks for replying Roy. I took out sensitive information from the word document and it does not work well in excel.


    i just thought a VBA macro auto open event could trigger "steenkampc" to the windows logon name that was signed in.


    i thought it was possible because the power of excel vba is awesome

    Good day


    i have an excel vba macro userform that when u enter information it will update the excel sheet and then transfer it to a word document that will open and print it automatically.


    everything works fine but i want the username to update on the word document and also in the vba code.


    we are linked to windows server which means that when u want to log in, u press ctrl+alt+del and then type in your username and password.


    i found this piece of code on the internet


    Code
    1. Function GetUserName() As String
    2. GetUserName = Environ$("username")
    3. End Function

    when u type in =GetUserName() in any cell on the spreadsheet and run the macro, i it updates the name like it should


    my question is where in the vba code in excel and word do i put it in so it can update that name automatically.


    then i dont have to change the name manually for other people on the network.


    the word file is saved under the Documents\Templates folder


    here is the code that prints to the word file


    here is the call to XPrint


    Code
    1. Private Sub cmd_Print_Click()
    2. Call XPrint
    3. cmd_close.SetFocus
    4. End Sub

    im attaching the file

    Files

    • getusername.xlsm

      (23.34 kB, downloaded 7 times, last: )
    • Receipt.docx

      (26.1 kB, downloaded 6 times, last: )

    i want the user to sign in with his name starting with surname and initial like "steenkampc"


    i want the name in "Permit" sheet in cell D5 to reflect as C. Steenkamp because it uses a vlookup function in "List sheet" to return values in H5

    under sheet named "Permit"


    for example. you type in your employee code 123 and it must show Roy in cell A1 in Sheet1


    maybe an IF function will work


    if cell C2 equals steenkampc then cell D5 must be C. Steenkamp

    Good day.

    Please help with this vlookup function.


    i have three sheets and a userform.


    if you type in steenkampc on the userform, it must show C. Steenkamp taken from (sheet "List", Cell A3) in sheet "Permit"


    Cell D5

    Files

    • vlookup.xlsm

      (31.39 kB, downloaded 3 times, last: )

    Good morning. We have a program at work where u scan the barcode on the document then it will transfer certain information from the certificate into textboxes on the program.


    I do not know in which language the program used is written but I was thinking of doing the same thing. I googled for more information but maybe the terms I am using is not correct.


    Can anyone point me in the right direction where I can do more reading?

    good morning from Namibia


    I am uploading a userform where i removed most of the textboxes and code


    as u type in the numbers, it automatically calculates the into textbox1. i want the same result to SHOW in textbox34.


    also i am using a code i found on the internet where it captures a screenshot and prints. it is possbile for the windows taskbar not to show and make the size a little bit bigger?

    Files

    • Cashup.xlsm

      (78.69 kB, downloaded 7 times, last: )

    Hi to all


    i want to adjust it with my sheet so please help with the following


    Normally when we create a userform one uses a listbox to select something e.g a name.


    when the name is selected, it transfers it to a sheet. i now want when u login using a password login form that name should appear on a sheet in the excel workbook.


    i am uploading such a form


    i want if a name is selected e.g Jan1, the name Jan1 must also appear on sheet3 cell D5 for example.



    the reason for this is there will be a userform so i dont want users to choose someone elses name when they open it.



    everyone will be able to change their passwords at the beginning and when you print out your sheet at the end of the day, your name must appear there.



    kind regards

    Good morning


    Please help me. i am attaching a file. when u open the excel file and click on login it asks for a username and password. u can use mine just check on the admin sheet.


    i want when its correct to open sheet1.


    can u provide me with the vba code please.


    thanks in advance

    Good day, hope u can help me.


    i have a cashup sheet with textboxes (the one on the left and the middle)


    when i type in amounts they automatically calculate at the bottom at total amount and total eft.


    however. when i click on the red no entry sign the amount is cleared but the total is not affected.


    i want when i type in 10 and it shows 10.00 at the bottom and clear it, the 10.00 should go away.


    i am uploading the file for you

    Files

    • Cash.xlsm

      (53.6 kB, downloaded 15 times, last: )