input box help

Hello, I have recently started to code a macro to help me repetitive data analysis with very few knowledge in coding languages. I have came up with this code, the idea is that I import my data on the sheet "raw" then I select the different series of values and name them in a new sheet. Since I...

: hi all, please help me in the below vba code, as beginner in the work sheet, just want to insert the multiple rows through input box and insert after which row through input box. then i make which row to be copied through input box. i cannot paste the copied row to the number of...

I can't for the life of me figure out how to adjust my code to offset the location of where the answer to my second input box question goes. How my macro is supposed to work. . . if A4 (for example) is my active cell and where the macro starts, that's where I want the answer to the very first...

Hello I am quite new to VBA and can navigate myself around it (sort of) but have come up stuck with this issue. What i am attempting to do is 1. copy sheet6 2. rename the new sheet based on the input box text 3. if there is an error (sheet name exists) then go back to input box to rename. I...

Hi, I am having an issue with the code below. Every time it runs and I enter a company name with an apostrophe an error is thrown that reads 'type mismatch run time error 13'. I am fairly new to vba, I have however tried to double up on the quotation marks *If Evaluate("isref('"" & ActNm &...

Hi, I am fairly new to vba and am trying to work through a spreadsheet. At the moment I have managed to create a macro via vba as shown below. It currently works via pressing the required button and an input box being displayed which asks for the name of the new sheet to be created. The new...

Below I have VBA for a user to enter a date and for that to be entered into a specific cell on the active sheet. I do not have a lot of experience with Or statements. I want to add an "or" path for a checkbox to be ticked, if this is the case then yesterday's date; formula =today()-1 would be...

Hello, I have an input box that prompts the user to enter his password to access the sheet. Is there a way to mask the password while it's being written by (*) ? Thank you

My input box fills the inboxfldr in this code Set Fldr = olNs.GetDefaultFolder(olFolderInbox).Folders(inboxfldr). If the object isn't found the vba gives a run time error. I want to suppress that error, prompt a message box that folder isn't found and just re-promt my inputbox. Looking for some...

I would like to put this inputbox value.... inboxfldr = InputBox("Enter Outlook Folder Name", "Inbox Alert Folder") Into the below so that the value that the user input replaces the "GLAM" in the Set FLDR line. Sub GetFromInbox() Dim olApp As Outlook.Application Dim olNs As Namespace Dim...

Hi Guys, I hope you are all well today. I am trying to use the below for an order form so that the user enters a Post Code Or AC number and this goes into cell E3 where the form will then produce the customers AC details. but for some reason the Value is not going into the Cell after it is...

Hello, I have created a code in VBA to convert dates from YMD to MDY as a Ribbon (Excel 2007) Problem is the code doesn't work unless the user specifies the Cell of the Header for the Column to be Converted. I would like to place a Message Box if someone typed C2 instead of C1 for example. So...

Question: I need help. I am trying to write a VBA to Copy Set rng = Range("A1", "T189") 26, or 27 or 30 times by using the InputBox("Enter repetitions") and it is not working. All in one worksheet. Can anyone help me with that Code

I am trying to create an input box that has an either/or type check box along with the standard input box. The user has to input a temperature and I would like to give them the opportunity to input in degC or degF and have the program make any of the necessary calculations before the number is...

I'm hoping this is an easy fix! I have an input box which works great but when the cancel button is clicked it brings up "Run-time error '13': Type mismatch". The code I am using is listed below. Any advise on how to have the cancel button just exit out of the message box? Sub gethours()...

I created a Macro with a button that copies a hidden master sheet, then prompts the user to enter a sheet name with an input box. The button works if the user puts in a name, but if they press cancel, exit out, or just press OK, without a name; the macro goes to the code with an error. When I...

<tbody> A B C D E F 1 Road No Road Name Code From To Length 2 A001 ABCD 111 A B 3 3 A001 ABCD 111 B C 2 4 A001 ABCD 111 C D 5 5 A002 EFGH 211 E F 14 6 A002 EFGH 211 F G 8 7 A002 EFGH 211 G H 9 8 B001 WXYZ 333 W X 11 9 B001 WXYZ 333 X Y 4 10 B001 WXYZ 333 Y Z 8 </tbody> Hi...

Hi again, I am using Input Boxes to fill in information in a table. I'm getting a runtime error 1004 (Application-defined or Object defined) when I tried extending the range one column over and filling that in with an Input Box. I'm not sure what the problem is. Could someone help me? Sub...

I am looking for a macro/formula to place into an input box, I want the user to choose either .5 or 1. I then want that number to be placed in cell A3. I know it sounds easy, but can't figure it out. Maybe it needs to be a different choice?