username

Hello, I'm new to MrExcel and could use some help with the following situation: Person 1 enters data in single row, various columns A through O, then hits a "process" button that I've inserted using ActiveX Controls. Their username and date/timestamp populates into that row, column Q. Person...

I have a simple DAX measure in my Excel 2016 data model: [Who Am I Domain]:=USERNAME() When I enter this as a measure in the data model window and use autofill the end parentheses appear. However, after the measure calculates the parentheses disappear (which they don't do for...

Hi, I am trying to transfer data to an external file from a worksheet using VBA: current date, username and a global range named cell "Score". Date and username is succesfully transfered to column A and B in the first empty row. "Score" however gives me an error. I don't know how to refer to...

Trying to create a form in Excel that will allow a technician to input a username, click on one button which will then search the sheet for that user name. If username is true, script then looks to see if equipment has been assigned to user. If false then a new form comes up, populated with...

Hey all, I'm in need of a code that will automatically insert the username of the person who makes a change in a specific set of cells. So for context I have cells C3, C29, C38, C42, C52 & A61 that start off empty by default. What I want is when somebody adds text to any of these cells, their...

I have a worksheet named "MINE" and need that when I open it my username appears in cell A1. I need that my username will be full name, example Tony Smith. Thanks in advance

So I used to work with a co-worker who used this excel macro to do his daily checklist and he sent it to me a long time ago. I never had the need to use it till now, when you double left click it timestamps the cell with the initials of your logon username and the date which is perfect for my...

Hi I want to make an if statement that looks for a matching value in a table´s column. Table name: table1 column: name I have a value being held in a variable called "username" (dont know if im explaining this correctly) If i do a code msgbox username i do get the expected value i want...

Hello friends, I need the code for VBA userform login to open excel using domain username and password. So, when user open a file, userform will be activated and user need to enter username and password, domain name will be automatically detected and written in 3rd line. But if user need to...

Hi All, I'm quite a beginner for VBA coding. But I want to use VBA for getting data from website where my steps are as follows 1. entering website 2. paste username and password 3. change the date to query data 4. click "download excel" 5. copy data from downloaded excel to my worksheet Can...

Hi All, I've been spinning my wheels on this and couldn't find any useful sources to help me with the following. I have a spreadsheet that is shared among of group of people and there are always mistakes that happen within the file. Thus, I want to identify who the last end user was, who...

Hello Excel/VBA Masters! I got a table and with info that needs to be verified by employee. Next to each row of information there is Data Validation list (Verified / Not Verified). I got formulas down that show the username and time+date of verification, than i i lock the cells if there is any...

I am trying to create a filtering scenrio. Ex. The value of Sheet1 in cell A2 is username "Admin", if that happens all Username with admin in Sheet2 will be filtered from the table of raw data.

I’m not sure if I’m posting this to the right place but any advice I can get will be appreciate. I want to Automate the downloading of files from 2 websites using Excel VBA. The first website Log on page has name’s and id’s for the Log on elements. The problem with the first website is that...

Dear All, I used Environ "User Name" method in my workbook to assign Visibility of sheets with respect to the users. Now, I dont want any of the users other than in the list to see all the sheets except one or two. Please guide how to do the same. Thank You. Regards Krishnamoorthy S

Hello I want to pass some variables from one sub to another and after doing some research I'm still unsure on how to achieve the outcome I want. Private Sub CommandButton2_Click() If isLoggedIn = False then Get LogIn(Username) End if MsgBox(Username) End sub Private Sub LogIn() Username =...

Hi there. Hope someone can help. I have data in A and B that is the Username and times scanned. I need to get the first time for the username F3 and the last time F6 of the user that they scanned. There is thousanfs of records per user Please assist me on this...

Hi all i currently have this formula. =COUNTIFS('Call Data'!$B:$B,"UserName", 'Call Data'!$F:$F,"Calltype1", 'Call Data'!$Q:$Q,">"&'Current Month'!E$3, 'Call Data'!$Q:$Q,"<="&'Current Month'!F$3) The cells E3 and F3 have weekending dates in them e.g 27/07/2018 and 03/08/2018 what i want to...

I am trying to set up a file to auto log into Hypersion. Declare Function HypConnect Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtUserName As Variant, ByVal vtPassword As Variant, ByVal vtFriendlyName As Variant) As Long Declare Function HypCreateConnection Lib "HsAddin" (ByVal...

Hi, I need a lookup formula that will look at a value in another excel spreadsheet but not entirely sure how to do this. Essentially it's - if 'username' (column I) matches 'username' (Column I) in spreadsheet 'R_US_0418 then 'Existing' else "N/A" Any idea on the formula required please to...