Search:

Type: Posts; User: bonriki; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    25
    Views
    546

    Hey guys My users now decide that wish to copy...

    Hey guys
    My users now decide that wish to copy up to 3 columns of mixed text, column 1 and data columns 2 & 3, into the P&L and GIT combo boxes. I have tried with column properties set but all I get...
  2. Replies
    25
    Views
    546

    sorry guys Had a problem with a variable but...

    sorry guys
    Had a problem with a variable but then realised the sub where the variable was defined was set to Option Explicit!!
  3. Replies
    25
    Views
    546

    Thanks Andrew and Maud for all your help Make...

    Thanks Andrew and Maud for all your help
    Make sense
  4. Replies
    25
    Views
    546

    Thanks Andrew The workbook doesn't seem to want...

    Thanks Andrew
    The workbook doesn't seem to want to behave. When I double click to open the file opens with Protected view warning with "Enable Editing" highlighted then when clicked it gives VBA...
  5. Replies
    25
    Views
    546

    Maud Thanks for that. I have used a combination...

    Maud
    Thanks for that. I have used a combination of Text Boxes and Combination Boxes on the UserForm.
    I assume your code will only work for Combination Boxes
  6. Replies
    25
    Views
    546

    Andrew Not sure I understand. My users wish to...

    Andrew
    Not sure I understand. My users wish to enter data, save it and then come back to it later by opening the workbook again. I didn't believe rerunning the userform retained the previously...
  7. Replies
    25
    Views
    546

    Sure

    Sure
  8. Replies
    25
    Views
    546

    RG Thanks for that Did a compile and doesn't...

    RG Thanks for that
    Did a compile and doesn't like line "Sheet1.Select" which I changed to read "Monthly Report.Select" and the userform is not populating with the saved data
  9. Replies
    25
    Views
    546

    RG I am having trouble with this bit, checking...

    RG
    I am having trouble with this bit, checking the sheet exists and then populating the form with the existing data.

    Your idea of a separate module looks good too.
  10. Replies
    25
    Views
    546

    RG hi again The file is set as an xltm so the...

    RG hi again
    The file is set as an xltm so the save function would be xlsx but of course that will not allow further editing. The intention is that staff generate the report monthly and send to...
  11. Replies
    25
    Views
    546

    Save user form for later editing

    Hi
    MS 365 on Win10
    I am wanting to be able to save data entered in a userform for later additions or editing before posting to final spreadsheet
  12. Replies
    8
    Views
    368

    Thanks Maude No it wasn't a test I could not...

    Thanks Maude
    No it wasn't a test I could not disable the start up code using the usual hold the shift key when opening, so couldn't get access to the code
  13. Replies
    8
    Views
    368

    Thanks Martin No code and about 40 sheets missing

    Thanks Martin
    No code and about 40 sheets missing
  14. Replies
    8
    Views
    368

    Tried it didn't work, same result. I have...

    Tried it didn't work, same result.
    I have attached the file to see if you can get into it45724
  15. Replies
    8
    Views
    368

    Automation error

    Need help with this.
    I have a shared Excel spreadsheet that is saved as a binary file, *.xlsb, that gives an automation when I try to open it

    45723 The file is a training record and has quite a...
  16. Replies
    30
    Views
    3,895

    Andrew Thanks very much for this I have had to...

    Andrew
    Thanks very much for this
    I have had to massage my files a bit but what you say makes sense and works a treat.

    I will deploy tomorrow and hopefully!! no problems
  17. Replies
    30
    Views
    3,895

    The code hasn't changed since you developed it...

    The code hasn't changed since you developed it but I would be interested in seeing how you would change

    Om another matter can you recommend a good text(s) as a reference for VBA coding
  18. Replies
    30
    Views
    3,895

    Andrew hi I have finally managed to get this...

    Andrew hi
    I have finally managed to get this sorted. Seems AD doesn't differentiate between case although it does seem to in some cases!!

    Next question, how can I make the userform dynamic...
  19. Replies
    30
    Views
    3,895

    Thanks Andrew The login details I have, have...

    Thanks Andrew
    The login details I have, have come from our IT guys. The IT guys inform me that there should not be any difference in the login verification for online or VPN even though there...
  20. Replies
    30
    Views
    3,895

    Andrew Another twist. I was certain the code...

    Andrew
    Another twist. I was certain the code worked fine after I changed the username detail. But connected via wifi at work didn't want to recognise my login. However, just checked gin at home via...
  21. Replies
    30
    Views
    3,895

    Andrew and RG Discovered that we use the user...

    Andrew and RG
    Discovered that we use the user initials as the Environ"UserName" so as soon as I changed mine to PGC every thing worked for both examples.

    Andrew I tend to agree with you the code...
  22. Replies
    30
    Views
    3,895

    Thanks Andrew I can't see any difference in the...

    Thanks Andrew
    I can't see any difference in the way this performs. It still loads the blank form in the background and then pops the warning message. So my UserName is not being recognised.
  23. Replies
    30
    Views
    3,895

    Sure It is in the attached *.dotm, frmSigInsert

    Sure
    It is in the attached *.dotm, frmSigInsert
  24. Replies
    30
    Views
    3,895

    Yes Checked my username and it is of the same...

    Yes
    Checked my username and it is of the same format "Phil Carter". As stated I have set myself as supervisor, not that I need to use the signatures, but because I need to verified that the links...
  25. Replies
    30
    Views
    3,895

    Thanks RG Looks better than what I was proposing...

    Thanks RG
    Looks better than what I was proposing
    However, having got all the code in it now will not recognise any users and we just get the VBWarning with a blank userform in behind, which is...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4