myvalue

Hello all, I have a small problem and I just can't make it work: - in cell a1 I have a drop-down list with "yes" / "no" - I need a solution that, if the cell a1 is yes, to make me write one number in cell b2 - it should not let me continue without inserting the number in b2 - I was thinking...

Hi: I have data in col A and B. I'd like to build a macro that, if it finds the term "trigger" in col A, it copies the data in col B to col C (all in the same row). But, if it doesn't find the term "trigger" in col A, it copies the prior successful data to col C. Here's what I have so far ...

I have code to open 1 of multiple folders, depending on the selection. Previously it worked like a charm. Now it hangs on MyFolder. I have no idea what is wrong. I have trouble shot it, & it hangs on the same location. Here is the code: Sub Partner_Resources()Dim MyValue Dim i As String...

I have the following code below Sub Input_Data() Sub Input_Data () Dim myValue As Variant myValue = InputBox("Enter The net income amount") Range("B3").Value = myValue myValue = InputBox("Enter Tax rate") Range("F4").Value = myValue End Sub I would like the following amended...

I have a macro that will ask for a date to append 2 workbook names and copy their data into the current workbook. I would like to add the names (File1 and File2) to a table on a worksheet in the current workbook. So this table will grow as the workbook data is added incrementally. I am having...

Hi and thanks in advance for your help, I have the following code which is meant to get two different pieces of data from two different worksheets in the same workbook: Private Sub CBanswer_Click() Dim s As Worksheet, myValue As String, f As Range Dim Q As Worksheet Dim myvalue2 As String Dim...

Hello All, New to this forum and looking for some help. I have the need to copy the values from the same cell in multiple workbooks in the same folder into a master file. I have come up with some basic VBA code that will sum the values of the same cell over multiple files and place that total...

Have a VBAcode: Want the user to be able to select the variable "entity" by selecting a row in a combobox... The combobox should have 2 columns with Entity; Entityname 200 ; Google 201 ; Amazon 202 ; Microsoft sub opentb() dim wb1 as workbook dim wb2 as workbook set wb1 = activeworkbook...

The following code is part of a bigger code. Gets an error when it tries to open the link? sub openfile() dim wb1 as workbook dim wb2 as workbook dim myvalue as variant myvalue = inputbox("Example: 0219", Which period should TB be run for") range("Z5000").value = myvalue workbooks.open...

Hey everyone! I would like my code (pasted below) to not only count all instances of variable "myValue", but to also count instances of myValue which is generated with formulas. As is, it will only count cells where myValue actually is the value rather than also counting cells where myValue is...

I'd appreciate some help on probably a simple problem. I want to clear the contents on Sheet1 of a range from row 15 to 51 but the column number is a variable based on a Input box (Dim myValue As Integer). When I run the VBA from the Sheet1 it works fine as follows ActiveSheet.Range(Cells(15...

Hi all, Please can someone help me with the below code. As you can see I am filtering based on what is placed in the input box. The cell "I19" is blank so I want the filter to bring up any row of data in which the cell is blank in the relevant column. I then want to copy select data out of...

Hi all, Can someone help with my code below? I cannot work out why it's not working? The line in bold is highlighted by the debugger. Sub Macro10() ' ' Macro10 Macro ' ' Dim myValue As Variant myValue = InputBox("Enter the confirmed start date below", "Start Date Confirmation")...

I have a named range "TAB" (B8:K26) in several worksheets of a work book. I am a retired want IT professional, new to VBA, and view the range like a file with the rows as records and columns as fields. I want to loop through the rows examining column D checking for an exact match to a value I...

Hey guys my third post i am sorry. I am new at VBA and trying to interact with what i am think is a GIF i need to click to expand the table. attached is the html and my current code. <div class="A976bc0611e7a4e20b05d61c1efb873f5818" id="Pcda281654e7f49028c2c6bb20cd0566c_1_601"...

Hey guy i am trying to add the value in A2, to the end of the URL here is the code Sub Assetgrabber() Dim myValue As Variant myValue = InputBox("Asset Tag") Range("A2").Value = myValue Dim ie As Object Set ie = CreateObject("InternetExplorer.Application") ie.Navigate =...

Hi, When I run this code. My aim is to have a user be able to pull data based on their selected criteria from the inputbox from a closed file (which isn't going to be opened). That closed file is updated (with a new file name) each week, hence the user having to select the file initially to...

Hello, I'm trying to create a check in/out system at a lab I work at. I'm not to experienced and using VBA. I was able to tinker with some formulas to get it to do what I wanted, but I wasn't fully successful in getting all the steps I wanted done. so what I'm trying to do is check in samples...

Afternoon all This is only my second post so appologiese if this is inthe wrong place. I am curently in the final stages of creating a spread sheet for documenting multiple bakup of multiple devces. as the spreadsheet is stored on a pc which is never going to be connected to the internet I...

Hi I have the following code below which works but as you can see is very manual in terms of the loop until the input entry is correct. Basically I want the code to check that the number the user has entered equals 19 or any row number from 19 with a step /increment of 7 e.g. 26,33,40 etc. up...