user

  1. M

    Looking up information using two columns

    I have a data set with the persons name in AD and the Date in AE - along with other data I will be pulling. Each date the users will be sending data on what they did that day. So in the data set, column AD will have the user's name listed more than once. As more than one users will be sending...
  2. O

    Hyper links when source worksheet hidden

    Can anyone help me please? I have a workbook with multiple worksheets. Worksheet#1 is the one that the user will beactively using. It has hyperlink to other worksheets within the sameworkbook. These other worksheets areinformation only. When I hide the otherworksheets, the hyperlinks stop...
  3. M

    Should I use Index/Match?

    I have a dashboard where col B is academic terms and col D is their total fees. I have a hidden sheet with the breakdown of their fees that I want to load on that multipage. When a user double clicks a term in column B a multipage in a userform pops up. So if Semester 1 is double clicked the...
  4. P

    How to insert a character while the user is still typing

    Is there a way to insert a character while the user is still typing. For example if the user is entering the date, automatically insert either a "-" or "," or "/", or a "." after the first two characters. For this instance I just need to insert the character after the two digit month followed by...
  5. S

    How to automatically run a macro upon opening a workbook (using a clickable prompt)?

    Hi All, I would like a macro to start running automatically as soon as I open the Excel file. However, a prompt would ideally appear first, which asks if the user wants to cancel the automatic start of the macro. The user has the option to click on the prompt (or hit a specific key or...
  6. E

    VBA code to print whole of UserForm

    Dear Experts, I am not able to print the whole of user form. My User form seem to be quite big and when I print using the following code...the user form which appears in the screen gets printed and remaining ones are not missed. Private Sub CommandButton2_Click() Me.PrintForm End Sub Can...
  7. H

    Combo Box not showing Data and need to search sheets based on combo box

    Hello, I have created a user form that lets me enter data onto different worksheets within the workbook depending on a combobox selection. My problem arises when I click the command button to open the 2nd user form. It opens, but the combobox does not display the entries I want to Show. Sub...
  8. M

    VBA Help - Want to close one excel file but not the other without prompt to save

    My User Form opens another excel file. I want to close this newly opened file when I want, but not have excel ask me to close my User Form interface. I have the below code in my ThisWorkbook VBA script window, but it still does not allow me to keep my User Form open after trying to close the...
  9. K

    User Log File - on Opening Template File

    I have an Excel Macro Template file on our Network for our Sales Team to use. I want to record the user name and time/date in a seperate user log file hidden from the user, so I can keep track and frequency of the file being used. This would be VBA Code as an on open-event or after open in my...
  10. JackDanIce

    Build Revenue Forecast tool in Access

    Hi, I'm working on a project to design a revenue forecasting tool in Excel, with various User input controls and restrictions and then need to see aggregate data from multiple files and different reports based on different views (e.g. Single Client, practise type etc) I think building this...
  11. A

    contact way

    Hello All, i make a simple user form to collect some data related to customers i make Frame contact 2 options call mail i need when the user select call an Text box active to write numbers only
  12. E

    vba code for multiple return values

    Hello i am new to VBA i am creating a user form to enter cash vouchers. The Problem i am facing is in searching back the results regarding 1 criteria . i uploaded the picture that can help u better understand my problem. I post several transactions with having one invoice number and i want the...
  13. L

    Create floating shape that stays visible on top of page when scrolling

    Hi, I have a button on top of each sheet and when clicked takes the user back to the TOC. 'Create & Position Shape Set Shape = Worksheet.Shapes.AddShape(msoShapeRoundedRectangle, 550, 0, 40, 20) I've added following code so that the shape stays in the exact same position when the user...
  14. gheyman

    Access: Timestamp new records

    I have a table where I put a field in named "_TIME_STAMP" Whenever a new record is entered into the table I want to capture the date and time in this field Note the user is entering data into the table via a Form (Splitform). What is the best way to do this? Accesstbl_VendorQuoteData - Table...
  15. NessPJ

    2 data tables with a user selection to feed 1 final table?

    Hello, I was actually looking for a way where i can have 2 data tables, with data by day where a user can select which data should be used\shown in table 3 (the input table). Which formula or VBA should i use to achieve this? The input table should be dynamic so there will be no empty or zero...
  16. B

    Rename File from Hyperlink on a Sheet in Excel VBA

    I have a sheet which lists many relative hyperlinks. The 'text to display' is the filename. Using the 'Worksheet_Change' event to monitor, if a user changes the filename in the cell the actual filename should be renamed to the new value, so the user doesn't have to open the folder and manually...
  17. P

    Data Validation

    Hey guys , I need help with data validation. I want to allow user to type data in V11 and W11 only if O11 and P11 has data in it So if cell O11 and P11 does not have any data in it then a user cannot enter any data in V11 and W11 I will apply data validation to V11:W31. Data in O11 is...
  18. N

    VBA help - Showing Username of Person Updating Spreadsheet

    Hi. I have a Userform that some users complete to update info on a (large) table. I've added a bit of VBA to get the date added when the user who has opened the spreadsheet makes a change to the database but I'd like to be able to add their name too. However, when I use Application.Username I...

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top