user

I need to create a list that shows the outcome of everybody's ranking of a list of items -- from most important to least important. Whatever item gets the most "votes" for being the most important will be the first in the list, the next item with the most votes gets the second, etc. My users...

Hello everyone, I am currently trying to create a detailed overview of transactions executed by a range of different users in the hopes of creating a easy to understand overview of performance. Which will include the points listed below. In this performance overview I want to include several...

I have a MS Access application that is used in multiuser environment. I want to make maintanence every thursday between 15:00 and 16:00. At this point I have two issues to consider. Firstly, The users who may entered to application before 15:00. Secondly, the users who will be entering between...

I have 3 cells, each cell has a value, 1, 2, 3 The cell value is related to a score, each score located in another cell, 10, 8, 0 To pick a value, the user has to change the cell colour, for example the user picks the cell with 1 and shades it any colour Then the formula needs to pull in the...

I have a very difficult and specific request that I would like a lot of help with please. I have a very large macro-enabled workbook with around 260 sheets. Originally, I used some VBA code so that no matter what sheet the user was on when they saved and closed the document, the next time it was...

Hi All I am currently using the below function to show if a row is hidden or not, when i first use the function it works perfectly but as soon as i unhide/hide a row all the values change to #VALUE . What am i doing wrong? Public Function isvisible(rng As Range) isvisible = Not...

Hi, I have a user form(UserForm1) which I want to show at the start of the maro & hide at the end i.e. when the macro/code is completed. The purpose for this is that some codes do take few seconds to complete so I would want a user form (stating some text like the macro is ruuning - pls wait...

I have a large list of items that I want to verify. There are two sheets, one with the raw data and the second with a list of items. Set up kind of like this: Sheet One <tbody> Host User host1 user1 host1 user2 host2 user1 host2 user2 host3 user3 </tbody> Sheet 2 <tbody> Host User...

Hi All, I'm new here, so firstly nice to meet you all! Trying to work out a way to approach this situation. I have a set of data similar to the following. What I want to do is find a way to only show the 2 most latest (most recent date) for each User. For example: <tbody> Date Name Value...

Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a user. Example- "F" in a cell becomes "F:" A2 has to always be three digits- so if a user puts in "1", the cell shows "001" or if a user puts in "20"...

Hello, I have a table with many rows and columns. Each row represents a course a user still needs to complete. The row will have the user's name, and a bunch of other columns, including a "People.Temporary" column which indicates if the user is a temporary employee. If the user has more than...

Hi all, I'm looking some help with referencing a combo box in a outlook form. I have a total of 4 pages/tabs, the first is where the user will select from a combo box and depending on which option is selected this will navigate the user to the correct page. I've never used vba in a outlook form...

Hi All, I am having a set of data containing several rows and columns. This data contains "User Name" in one of the columns; however another column contains the Date on which he accessed a document. One more column has this document ID. Now, I need to randomly pick the entire row for each of...

Hello everyone, I have a command button that opens up a user form, I would like to add a yes/no message box to the command button and when cell "A4" =01 (01 representing today's date). My message would read"do you want save the data and delete before entering new months data". If yes is...

<tbody> User ID Amounts Posting Date 11 $500 2017.07.24 11 -$150 2019.04.05 11 -$200 2019.05.10 11 $200 2019.06.24 11 -$350 2019.06.25 11 $600 2019.09.03 11 -$100 2019.09.07 11 -$200 2019.10.03 </tbody> I there a way in which I could automatically...

Hello Friends, I am using the below code which is linked with Workbook open event Private Sub Workbook_Open() Application.Calculation = xlCalculationAutomatic Call show_index_sheet Sheets("INDEX").Unprotect Password:="merchant" Sheets("INDEX").Range("A1").Value = GetMACAddress() If...

Hello all, I have a tricky problem that I can't solve, and I would like help from more experienced people. I have a gantt chart to show the progress of tasks by user. Bar colors are made by conditional formatting, but each cell that is painted also has a value of "1" (while unpainted cells...

I have code that checks a table to see if the Current User should be able to open a form Private Sub Form_Open(Cancel As Integer) On Error GoTo Error_Handler If Nz(DLookup("UserName", "tbl_Users", _ "[Object_Name]='" & Me.Name & "' AND [UserName]='" & CurrentUser()...

Hi - i'm using the code below to show open workbooks which the user can then select one. How do I update the code to allow the user to select multiple workbooks and how do I name them? Code in a Module Dim WB As Workbook For Each WB In Workbooks UserForm5.ListBox1.AddItem WB.Name...

hello All.... I have an excel input form where the user enters a WORKORDER NUMBER (WONUM) and Asset assigned. Most of the time there will be multiple assets per wonum, each of these assets are a separate entry. What I'm trying to accompish: I want a text box that will list these assets in a...