input box

Hi All, Please could someone help with an issue I'm having? I've started making a macro which a user enters a string of letters for example CCGTXYZA, each letter represents a value which is given in the spreadsheet. I would like to sum the total and msg box the result. How can this be done...

I'm trying to get this code to open a file for me: Sub openfile() Dim A As sting Dim B As String A = Application.InputBox("type value of A here:") B = Application.InputBox("type value of B here:") Workbooks.Open Filename:= _ "D:\Users\" & A & "\Documents\" & B & ".xlsx" End Sub...

I want to get a name from user input in inputbox, and then use that name throughout my code in place of [Table2]. See below for sample. I have searched for an answer for a long time. Please Help. Set ws = Worksheets.AddSet pc = ActiveWorkbook.PivotCaches.Create(xlExternal...

Good morning! Using VBA I am creating a dynamic array using the values present in a text file. Users are then prompted to type in a value via an input box; if the value entered in the input box is not in the array, an error message appears, prompting them to cancel or retry their entry. In...

Hello, I have been working on a simple calendar tracking spreadsheet which has many formulas and and other macros. Therefore, I must protect the file from accidental user deletions. There are some cells that are protected such that you can't even select them while others you can select but not...

I have searched and searched, but not found an answer to this: I have a workbook that is shared by users, and needs to be auto-closed after 10 minutes of inactivity. The VBA code to close the workbook if no changes have been made in 10 min works OK. However, I want to give a user who has been...

I have an input box that requires user input of a cell range. The columns are always the same eg. D:H. These columns cannot be varied. The row numbers do vary. Can anyone please tell me how to restrict entry to (for example) D50:H80 or D150:H250. Thanks in advance,

Hey so I'm trying to make something in VBA that would make you input current payment and additional monthly, as well as select a range of a column that consists of FX rates. Then enter in the current month and calculate the information up to then and post it in this kind of format. It's going to...

in below vba code , i would like to replace all "B" in this code by range selecting or entering from application input box , kindly advise , Sub ahmed_code() Dim lr As Long, r As Long, x As Long Application.ScreenUpdating = False lr = Range("B" & Rows.Count).End(xlUp).Row For r =...

I am trying to write code which changes the color of text added to a string through an input box. It works great if I only have to add colored text to the cell once, but when I try and add any more information through the input box it resets the color of all the text. What I want to do is keep...

I am new to VBA and am not sure how to write this correct macro. I want to add the sum of an existing value (the active cell) with the amount I want to enter through a input box. What I have so far is: Sub AddValue() Dim myRebuy As Variant ActiveCell.Value = ActiveCell.Value + myRebuy =...

does anyone know how a can change to title of an InputBox and have the text that the user puts into the InputBox appear in a cell ?

First of all, thanks to everyone who has helped me on my current project. I currently have a code to prompt for password before saving a metrics file, which only a handful of people know the password (and not too many are bright enough here to look in VBA to find the password :rofl:) I was...

Hey guys :) I am trying to create a code, so that once the user types text into a input box, searches google with that text and returns me with the first 5 searches as well as there hyperlinks. I know its something to do with a tags or h3 tags but I'm not really sure.

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

First of all, I am not an expert when it comes to VBA codes so please simplify your answers. We are asked to make a program that budgets money. The first part of the program is an assessment. One of the questions is "Do you want to limit your food allowance?". I tried using a yes and no option...

Hi everyone! I have a small problem and I really can't figure out how to solve it. I have a sheet called "TIDRAPPORT" where i have lots of rows with lots of info. You can say it's a "time report excel document" for a company. What I want to do is calculate the amount of time each person has...

Hi, <o:p></o:p> I am struggling to create a VBA code that prompts user input via an input box upon finding a blank cell in Column O, then continueing onto the next blank cell in Column O, again prompting an input box, then finishing when there are no further blank cells in the column. Also, I...

Hi, I am fairly comfortable with VBA, but definitely still consider myself a beginner. I need some help with coming up with VBA module to accomplish the following: I have labeled data columns in A1:F345. I need my users to be able to click on a box to launch the macro and enter a search word...

Hi All I found some code online to run a basic value search on a column. I have modified it to suit my needs, but as I would like to add the function to "Try Again" if the returned result is not the correct one. I need this because the search is for names, and the sheet used by lots of people...