user

I'm trying to figure out the best approach for this task; - user selects yes or no from a dropdown (or a check box would be nicer visually) - if user selects no, nothing happens - if user selects yes, a further 4 "questions" need answering, the possible answers should be from dropdowns not...

I have a start up page for my spreadsheet that allows a user and a site to be selected. Depending on the user, I want a signature that is stored on the sheet Users, inserted in the following format onto sheet1. The signatures are stored in sheet 2. Dim shp As Shape Set shp =...

Good Evening All, I'm trying to select a range of cells based on what a user enters into an input box. In theory the selection I want to copy will always start in row ten so the user would just have to enter the column (it would be beneficial to know if a person can enter a specific cell ex...

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...

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...

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...

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...

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...

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...

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...

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")...

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)...

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...

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>...

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...

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...

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...

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

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...

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...