Onedrive with 10 users. How to store the login simultaneously.?

[quarna]

Hi

I have a workbook with a starting userform where the users select their name to login via combobox that is linked to a cell where name is stored.

So now you can save data to a row via buttons and do printouts via buttons.
But if another user are loggin in at the same time, that name from the combobox is getting stored at the same cell, so now the first user hast lost thier signature for printout, saving data etc.

I have not tried it yet, as the workbook isnt finished for sharing, but i am thinking that is how it will turnout at the moment.

So every PC that are opening the workbook will have their own unique name stored in a cell that i can use to log printouts etc.

 

[Micron]

Not sure I understand the issue completely but it sounds like you have to either
a) store each value in a different place
b) store each value in a custom collection or a dictionary object or an array
c) store each value in a tempVars collection
The array would be the easiest to create but will allow dupes if you don't code to prevent it. The collection will prevent the addition of a value that is already there but there is no easy test for existing values (beyond attempting and trapping any resulting error) if you need that. The dictionary provides for an easy test for existing but you must rely on dictionary keys for uniqueness. I don't know much about the TempVars collection.
HTH.

 

[quarna]

When workbook_open
A userform is loaded where you select a name from a list.
that name is beeing used as a signature, when printing.

I have a sheetA where data is written and and saved to sheetB in rows.
These data can be loaded back to sheetA when needed.
From sheetA i am able to print out a PDF with a signature. That signature comes from the list of names on startup.

But if multiple people are opening the workbook at the same time, that cell where the name is stored is overwriten ?.

I hope this makes a little more sense.

 

[Micron]

A bit, but it doesn't change my answer too much - except to add an option to get the Windows logged on user name and then lookup the signature in the sheet that matches it. Perhaps review as a start

Excel VBA Get Username - in 6 Easy ways - using Macro

Excel VBA Get Username code for Windows current user. File author, MS Office UserId, Network User, Computer Name using Excel Macro.

officetricks.com