enter

Hello, I'm stuck and need help please help me I need the following macro to work across 35 tabs after tab7 Sub FDADATE2() Dim SrchRng As Range, cel As Range Set SrchRng = Range("A:C") For Each cel In SrchRng If InStr(1, cel.Value, "FDA") > 0 Then cel.Offset(0, 2).Value =...

hi, I would like to be able to enter items from a workbook into another workbook . if possible to be able to type the first few letters of the item and have all the matching items come up in a dropdown list then be able to select the item and enter it in the workbook so that i can create a list...

Im trying to create a worksheet for tracking time and am having a little trouble with how I enter the time.. Simply I enter the start time in C3 and the end time in D3 and E3 (formula in E3= =D3-C3-0.5/24) shows the elapsed time. Is it possible to customize the way I enter the date like the...

I have code that enters text in a footer, how do I force vba to enter a carriage return in the footer so the text is on more than 1 line?

Hi This is what I am trying to achieve: 1. Enter the column name to find into cell B2 2. Enter the value to populate into this column into cell B3, however the table will be filtered so only visible cells are to be updated. Column_Name 1 will always have a value present in each row so this...

Can you use the range.find method to find the lowest row that the contents of a text box have expanded down to cover? For instance, if I have a regular text box with resize shape to fit text selected. I put the textbox in row 2, type "a" + hit enter, type "a" + hit enter, type "a" + hit enter...

Hi I wrote a code to ask user to enter first and last name and then the code will msgbox fullname. Now I want to improve the code. I want to msgbox the first letter for the first name then last name. So later I can msgbox the email address. For example, if user enter John Smith I want to...

I have a list of 200 names in column A and a corresponding list of rates in column B. What I need to do is be able to enter one rate and have that rate be entered next to each of the 200 names. So if I enter $1.00, $1.00 appears next to each person's name. Would I use a user form or formula...

I have a basic spreadsheet where staff enter details of events they're planning, it's in a set format so the date of event goes in a specific row. Even with only 4 events per month there's an issue with people not checking and trying to schedule them too close together. I've been asked to...

Hi, I’m getting tired of entering dates into a spreadsheet. I have a master date for each month (example: 1/1/2020) and want to create a formula so as I enter 5, the cell with the formula will show 5/1/2020 - relevant to the month/year of the master cell. I tried the DATE formula but could...

Good afternoon, I am attempting to streamline a tracking sheet being utilized by several of our employees. There are about 100 worksheets in the workbook currently, each named after a unique unit number. This makes it a nightmare to navigate efficiently and I am attempting to use an Input...

Hi, I have a number in Cell G1. This number will be either negative or positive. Im trying to write a formual in cell I1 that will display a 1 if G1 is negative and a 0 if G1 is positive. Thanks for the help! Rob

Hello world. I'm having an issue where I have and index and match with multiple return values but running into problems. Here's my setup: A B C D E 1 2 10A 3 [first] 4 [2nd] 5 [3rd] 6 [4th] =IFERROR(INDEX('BETA Care Plans'!$B$1:$B$215,SMALL(IF('BETA Care...

Hi With a help from Fluff, I created the code below. It is asking user to enter 3 numbers then the code will msg out these 3 numbers. I want to improve this code. I do not want to limit user to enter only 3 numbers. I want a user to enter any number and I will create a loop depend on how many...

I'm missing something here. I want the user to enter a number. If they don't enter a number, but instead they enter text, they get "Number is not valid" and the value entered is highlighted for the user to try again. If they select cancel they would get "You did not enter a number. Please...

Hi I want to write a code (for learning purpose) asking user to enter 10 numbers or whatever user going to enter then the code will find the max number from these number and print a message saying "number ?? is the max you entered". Can that be done in VBA? Thank you very much.

Assume I have this data on my worksheet from cell A1 through to B6: <colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody> 1 a 2 b 3 c </tbody> If In cell D1 I type: =MATCH(1,(A1=A1:A3)*(B1=B1:B3),0) and enter it "normally", I...

On my worksheet, cells A1 through to B6, I have the values 1,2,3,4,5,6 from A1, A2, A3, etc. In cell D1, I type: =SUM(A1:A3*B1:B3) and enter it as an ARRAY formula to get the result of: 32 I understand how this is arrived. It is multiplying cell A1 with B1, then A2 with B2 and then...

First let me say, I know very little about macros. I have a few personal macros that I use which I found online over the years, but other than doing minor changes to them I have just copied them from other sources and assigned a shortcut to them to run. I don't know how to actually create one...

Good evening, I have a column C3 in which I enter a value and a range (BU:CI) in which I also enter a value for each column. For each row (10000) I would like a macro to copy the formtting ( interior and font ) of C3 value if this value is the same in the Range (BU:CI) I have tried to write...