user

  1. M

    Error Handling

    Hoping somebody can help, I'm a rookie in VBA (but learning). I have the piece of code below and had 2 questions. 1. I would like to add code so that if the Path isn't available the spreadsheet doesn't give the user an error upon opening. This could happen if the user moves the file from the...
  2. B

    User Form Label format (date)

    Hi all. Long time watcher first time poster. Have searched he’d for a few days and am stuck on the below I have a user form that populates Labels with a date from a cell in a worksheet the date in the worksheet is in standard format. dd/mm/yy and is imported to the user form with no issue...
  3. S

    Formula question.. hopefully not to difficult

    I have a table with 47k records on it. Column J has a number of values. I am concerned with the tracking user "jjj222" Column D has Principal. Column E has repayment amount. What I am trying to accomplish: If borrower (column K) has a balance (D-E) with user jjj222 (found in column J), show...
  4. S

    Using Option Button to Set Variable

    I've got a command button that prints my workbook to a PDF with a specified filename and location, but I've been asked to add the option to save to one of two folders (without being able to browse to other folders). I'm trying to use a user form to choose the folder name, save it as a string...
  5. G

    Need help merging cels based on another cel

    All, I have been trying to figure out how to do this, but i have been unsuccessful so far. I have a spreadsheet (below is just a snippet) that contains the following information: <tbody> GROUP User Telecom-Corp User 1 Telecom-Corp User 2 Telecom-Corp User 3 Telecom-Corp User 4...
  6. kweaver

    VBA: cancel file selection

    I have a macro that prompts a user to select a file that is subsequently saved as a sheet and the data used in calculations. If the user cancels at the prompt to select a file, how do I avoid an error and just exit the macro? I suspect it's something to do with OnError, but don't know the...
  7. J

    Prevent user interrupting Macro ?

    Hi, i have a macro which depending on data size, can take up to 2 minutes to complete. Now ive found if whilst this is running the user gets impatient and clicks the mouse / keyboard etc.. then i get "excel not responding" -- Is there any way to prevent this? Was thinking maybe a userform box...
  8. L

    using control form checkbox in excel

    Hi I want to ask a question to the user and give 3 choices answers. Q) What is the color of the sky? [x] blue [] red [] green C1 = correct If user click on Blue then C1 will show correct. So I linked the first checkbox to B1 and I wrote in C1 the following =if(B1=true, "Correct", " wrong")...
  9. J

    Need a program to auto update of SI.No in Excel database

    Friends, I am developing task based database using VBA, I also developed user form similar to Data Entry (DE), * For that I need a program to auto update of SI.No in database automatically incremental immediately after invoking the DE User form using last SI.No in the (particular row)...
  10. K

    How to mandate text box in user form

    Dear I have an user form i want to mandatory text box (No. 3) please help Private Sub TextBox1_Change()[W11] = Me.TextBox1.Value End Sub Private Sub TextBox2_Change() [W12] = Me.TextBox2.Value End Sub Private Sub TextBox3_Change() [W13] = Me.TextBox3.Value End Sub Private Sub...
  11. J

    MsgBox when a certain percentage is reached

    Hello there, SheetA is where a user can input a type of animal and labelit 1 or 0. The sheet is interactive and is in a list form where the user can continuouslyadd animals and labels. <tbody> Bird 1 Dog 0 Cat 1 </tbody>...
  12. A

    Help With User Defined Function

    I haver a user defined function to take the second to last word in a string and add 1 to it. When I run the macro with the function in it, I get "Sub Or Function Not Defined". When I go to the debugger, the "Rept" function is highlighted. User Defined Function: Public Function SECONDWORD(sw...
  13. sharky12345

    Prompt user if file save is cancelled

    I have a routine which prompts the user to choose a folder to save an embedded Word document as PDF; FilePath = Application.GetSaveAsFilename(InitialFileName:=File121, FileFilter:="PDF Files (*.pdf), *.pdf", Title:="Select Folder to save") It works fine, except if the user clicks cancel in...
  14. B

    Chart legend in columns, not rows

    I have a chart with eight columns, labeled by the legend below them. Excel defaults to listing these elements left to right, and then down, thus: 1 2 3 4 5 6 7 8 I think it's more user friendly for the legend to display columns: thus: 1 5 2 6 3 7 4 8 Is...
  15. J

    Filtering a Pivot by user input value?

    Hi, I have a pivot table with the left column numbers 1-100 And I want to be able to filter between 2 numbers (from user inputboxs for min and max) Eg. Numbers 11-20 or 1-80 Unsure how to do this, Any help appreciated
  16. S

    TextBox Exit Event

    Hello Everyone, Have used this site many times as resource for my excel vba needs. Was hoping an individual could with a specific problem involving Win10. I have developed a userform to assist in a rework process. Intended result is user to enter a serial number using a textbox, if...
  17. B

    File Format

    Good Evening Could someone assist. I am attempting to save a current sheet (Active sheet) into a new workbook and include in the Name the reference to Range B2 which is Start & C2, which is the user input date. Also would like to include B3, which is the End & C3 which is the user input end...
  18. M

    Application Quit closing down all instances of Excel

    I've been fighting with application.quit for a while now because it wouldn't close excel. I had this in the open even and first check to see if the user had read write privileges to a folder they will need for everything to work. I got that squared away by putting and Exit Sub after the...
  19. A

    Sum between rows

    Hi community, I want to know how can i calculate numbers between specific rows? if user selects January from data validation list i want excel to calculate numbers from January to august, if May than from May to August. btw user can select start and end date. so it can be from january to may...
  20. D

    Identify unique values

    Hi Excel gurus, Could someone please help me. I have a report with users group assignment in the system. Users are assigned to read-only and full access groups. Email address is the unique field in the report. I wanted to apply a formula under User ID's so we we can identify and filter if...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top