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...
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...
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:
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:
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"...
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...
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...
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...
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...
I there a way in which I could automatically...
I am using the below code which is linked with Workbook open event
Private Sub Workbook_Open()
Application.Calculation = xlCalculationAutomatic
Sheets("INDEX").Range("A1").Value = GetMACAddress()
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
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...
Dear Learned people,
the following code is meant to present a user with the opportunity to be able to select a file that is in the folder "01_ElementLists". currently the code only takes the user to the list of files residing on the desktop, and the user must then know what the path to the file...
I have a user that occasionally experiences this error -- "Update or CancelUpdate without AddNew or Edit"
The db I administer has about 20+ end users, split db, front end accde files on each users's desktop.
This error occurs (only occasionally) when he is creating a new entry into...
Hi, I would like a user form date input field where "dummy" characters appear in the field when field is selected i.e. dd/mm/yyyy. These characters should be greyed out. When the user starts input to the field, input would overwrite the "dummy", in black. My attempts up to now have resulted in...