Input Dialogue Transfer To Msg Box

Mar 27, 2007

I have a range of cells in a column where I put in properties of contents of another range of cells. If i put in the word "broken" in any of those cells (say B12) i like to have an input dialogue box popping up automatically. This is where the user 1 is supposed to give a brief description of the broken item.

The next user, 2, (which repairs the broken item) shall gain access to the written info made by the first user just by selecting cell B12. I like it to be a MSG Box that pops up automatically when the cell is selected. Just to clarify: The MSG box shall contain the words written in the dialogue box by user 1.

Does anybody have a clue how to achieve this?

View 8 Replies


Transfer Data Without Input Box

Jan 20, 2007

I'm trying to convert this code so it transfers the data without the input box being needed.

Dim response As Long
Dim strLastRow As String
Dim rngC As Range
Dim strToFind As Variant, FirstAddress As String
Dim wSht As Worksheet
Dim rngtest As String
Application.ScreenUpdating = False

Set wSht = Worksheets("Transfer Sheet")
strToFind = Application.InputBox("Enter Your Initials")
If strToFind = False Or strToFind = "" Then Exit Sub

With ActiveSheet.Range("H2:H5000")
Set rngC = .Find(what:=strToFind, LookAt:=xlWhole)
If Not rngC Is Nothing Then
FirstAddress = rngC.Address

strLastRow = Worksheets("Transfer Sheet").Range("A" & Rows.Count).End(xlUp).Row + 1
rngC.EntireRow.Copy wSht.Cells(strLastRow, 1)
Set rngC = .FindNext(rngC)
Loop While Not rngC Is Nothing And rngC.Address <> FirstAddress

End If
End With

View 12 Replies View Related

Transfer Info From One Sheet To Another Depending On Cell Input

Jun 26, 2012

I am wanting to transfer data from one sheet to another depending on cell input


If I enter "2" in sheet1 cell B1, then I want a macro to take A1 to sheet2 but place it in A1 & A2.
Then say I enter "1" in sheet1 cell B2 goto sheet2 and put A2 into A3 and so on.

Depending on the number entered on sheet1 column B, the Macro duplicates the info from Column A in that row into column A on sheet2. ??

View 5 Replies View Related

VBA Save As Dialogue Box?

Mar 20, 2013

I am looking for a VB Code that will populate the Save As Dialogue Box, and it will have a file name prefilled, MacroEnabled.

For example (MyFile_123.xlsm)

View 3 Replies View Related

Rename Sheet Dialogue Box

Dec 22, 2006

I am receiving a the 'Rename Sheet' dialogue box when I double left click on a tab? Normally, it will allow editing in the name of the tab, not a pop up.

View 9 Replies View Related

Save As Macro For Dialogue Box

Oct 28, 2008

I would like a macro that will call up the SAVE AS dialogue box and populate it based on the contents of a cell. So far, I can save the file with a name taken from a cell but I'd like the user to be able to choose the location. I haven't been able to crack that yet.

View 9 Replies View Related

VBA Cancelling The Open File Dialogue

Jul 20, 2009

I have this code, the problem is when I try to cancel the Open File dialogue it gives me an application defined error and I tried it a dozen ways and it keeps giving me the same thing.

View 3 Replies View Related

Open Save As Dialogue With ;xls As The Default

Feb 21, 2010

Using Excel 2007

I have made a macro in a xltm book that will open the "Save As" dialogue but I would like it to default to xls file type instead of the user having to select it in the drop down box.

In addition to this I would like it to name the file based on a returned "=NOW ()" function from a cell (sheet1!G13) that has been mdms date formated which returns an unique document number each time for our reference.

Here's the code so far which works fine for the "save as" dialogue box part

View 14 Replies View Related

File Name Entered Into (Save As) Dialogue Box

Oct 16, 2011

I have a vba procedure that concatenates the name I want to use as the file name and stores it in a variable named ""NuFileNm".

Is there a way to have the vba open the "Save As" dialogue box and enter the NuFileNm string into the "File Name" box ready for me to manually specify where I want to save it?

View 1 Replies View Related

Keep Autofilter Custom Dialogue Box Open

May 6, 2007

I wish to use the custom option on autofilter several times. The problem is it closes every time I enter a new filter criteria. Is there a way to force it to stay open until I choose to close it? That way I don't have to use the pull down list to choose custom every time.

View 3 Replies View Related

Possible To Call Find & Replace Dialogue Box Within Workbook?

Jul 20, 2009

Yes, another homework for you guys. I have found the code to open the "Find and Replace" dialogue box but is it possible to open it with "within:" Workbook instead of Sheet?

This is the code that open up the dialogue box ..

View 6 Replies View Related

Auto Answering Save As Dialogue Box During Macro Run

Aug 1, 2007

I have written a macro which opens a worksheet, performs various operations on it, and closes it again. The problem is that upon close, two separate dialogue boxes appear - one asking me if I want to save, the other asking me if I want to keep what I have copied in the clipboard.

Is there a way of answering these dialogue boxes (or suppressing them) from withint he macro, so I do not need to manually click on Yes or No each time the macro is run?

View 9 Replies View Related

Import Text Dialogue/Wizard: Select File Once For Multiple Queries

Aug 7, 2006

I am importing a text file that has a lot more than 256 columns. The data will be updated weekly with a different text file. I know how to get past the 256 column limit when importing a text file like this. This link explains the method I am using to import the text file. [url] Since I am importing onto several sheets I get the dialogue box asking me to choose a file to import from for every sheet when I use RefreshAll. The same file that is used by the first sheet will be used by the rest of the sheets. Each sheet just imports a different section of columns from the text file. I want to avoid choosing the same file 30 plus times (once for each sheet) when I click refresh all. Is there a code that would allow me to choose the file for the first sheet, and the other sheets would follow suite?

View 9 Replies View Related

Copy Range From Sheet - Dialogue Box To Ask For New Sheet Name Then Paste

Mar 11, 2014

I have a sheet named "Fittings Summary" with an export button. I need some code that will copy range A1:G38 of the fitting summary sheet then open a dialogue box asking for the following "Please Enter Tag No" once a tag number is entered I would like a new sheet to be created in the same workbook named with the tag no entered previously then the copied cells pasted into it. I would like to keep the formatting of the cells but not the formulas within.

View 10 Replies View Related

Input In Multiple Cells To Generate Input Into Single Cell?

Feb 22, 2014

I have a spreadsheet with 5 columns. A1 to A5

Entries are made into columns A2 to A5 but only ever one entry across all cells

If an entry is made into A2 to A5 the I need a "P" to be placed into A1

View 4 Replies View Related

Input Box To Create And Input Info Into A Formula Which Then Populates A Cell With A Value

Jul 24, 2014

I am trying to create a macro which gives me an input box. I need to enter 2 numbers into the input box. It would be as follows:

Input Box Msg 1 - "What is your labor cost?" (NUM1)
Input Box Msg 2 - "What is your productivity rate?" (NUM2)

Then I need the macro to take this info and enter it into a formula which changes according to the row which you are on. (I need the macro to work based on which ever cell I currently have selected). The formula would be this if I currently had a cell on row 10 selected:


So, if I currently had cell L10 selected, and I ran the macro and put 100 in for "NUM1" and 10 for "NUM2" and my sheet had 20 in cell H10, then the macro would enter the number 1,000 into cell L10. If I had L500 selected, then the macro would enter the final number into cell L500 based on what value H500 contained.

View 9 Replies View Related

Transferring Of Input From Input Cell To Output Cells?

Jun 8, 2014

I would like to know if it is possible to transfer values of cells this way?

I've attached the excel file for easier reference.

View 3 Replies View Related

UserForm Input (a Button That Opens An Input Box Or Dialog Box)

Jul 4, 2006

I have to design an input user form (a button that opens an input box or dialog box), which asks user to "Enter number of "columns"".

User enters a number i.e. 2 or 3 etc

It then asks user for the headings of these coulmns and places first column heading in A1 and second column heading in B1, third in C1 and so on ...

View 9 Replies View Related

Input Text In Given Cell After Any Input In An Area

Feb 28, 2007

I am just starting to get my feet a little damp with VBA and I am trying to make a macro that will act whenever any text is entered in any cell within a 3x3 square. Whenever any text is entered in any of those cells I would like it to enter a text ( "X" ) in a cell which is specified by a cell in the spreadsheet (this cell will output which cell the macro should write the text in in this format "A:1" or "C:3"). How can I make the program act only in reaction to the user entering thier text, and also, how can I get the macro to read A:1 and enter the text into that specific cell? Any help would be so awesome, the book I have is really difficult to navigate.

View 9 Replies View Related

File Open Dialogue Box To Open In (Directory Of Tool File)

May 31, 2013

I have a tool file which contains Excel VBA codes. When I click button it asks to select a file. I want that anytime I click the button the dialogue box should open in the folder containg the tool.,

View 1 Replies View Related

How To Change An Input Box Based On Input In Another

Dec 9, 2008

What I am trying to accomplish....

If the input changes in D5, K11 will reset to $0.00..

Example. If cell K11 is set to $300.00, and the corresponding input in D5 is '123', when I change the contents of D5 it sets K11 back to '0.00'.

View 9 Replies View Related

VBA To Automate Text Input Into Input Box

Feb 6, 2014

I am in need of VBA code so that I can fill out an input form generated by someone elses macro input box. (I am the user, not the one developing the input box).

I am working to streamline a whole cluster of macros and this input box is currently my bottleneck. When the input box pops up, instead of me manually typing, I want to autofill the space with "104" and then click 'ok' uisng VBA.

I can not modify the actual VBA that created the input box (ie make 104 the default) because other users need the box to be blank.

find out how a developer would change the original vba code, not how a user can interact with an input box by using vba.

View 3 Replies View Related

Input Box Allow To Input The Column Number

Dec 5, 2007

I want to create an input box that will allow you to input the column number it should start in... so instead of it being fixed at A, you can choose column B, C, D all the way to the end if you like.

Sub SplitSheetsNoDelete1()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim Lmainsheet As String
Dim Lrow As Integer
Dim lcontinue As Boolean

Dim LColamaster As String
Dim lcolatest As String

'Retrieve name of sheet that contains the data
Lmainsheet = ActiveSheet.Name

'Initialize variables
lcontinue = True
Lrow = 2.....................................

View 9 Replies View Related

Transfer X Row To The End

Nov 12, 2006

in my worksheet if i have in any cell of clomun k eg.rnage (k1:k50) the word "fail" i want to transfer all of the data in this row to the fist empty row =to the end of the used rows

View 9 Replies View Related

How To Word Value Transfer

Jul 11, 2013

I have an excel sheet that contains different values in data cells for example: A10, A22, A45 etc.

I want to have a button which when clicked, should create a word document from a template and the values at these cells should go into the template file. Thats it.

So say when the button is clicked, the newly created document should be something like this:

The award goes to Mr. Value in cell A10 living at Value at cell A22 of amount Value at A45

View 8 Replies View Related

VBA To Transfer And Transpose

Mar 23, 2009

I have an attached workbook, and looking to find out how I can copy from one sheet to another.

What I'm looking to do is this,

On Sheet StaffRota I want to take the Name, Service, Date, Days, and then Start & Finish and copy onto the ExportRota Sheet as shown.

How would this be possible?

View 4 Replies View Related

Transfer Value From 1 Sheet To Another With VBA

Jun 18, 2012

I am wanting a macro that will open an existing workbook (book2) and transfer information from the already open spreadsheet (book1) to the newly opened one.

So far I have

Sub email_sheet_and_save()
'ChDir "\sbscompanyfolder1"
' Workbooks.Open Filename:="\sbscompanyfolder1QUOTE LOG.xls"

Dim iRow As Long

[Code] ....

I cannot figure out the code to make the actual transfer eg cell C2 on book1 should transfer to (irow, 1) of book2.

View 2 Replies View Related

Transfer Textbox Value To Next Available Row

Sep 12, 2009

Need Code to transfer text from a textbox to the next available row in a sheet. The sheet does not have a name as its populated at the same time you click the add button

View 9 Replies View Related

Data Transfer From One Tab

Feb 4, 2010

I have a spread with five tabs. Each tab is a person's job responsibilties for numerous properties. Each person works with a property called Orange Avenue. I want to create a tab for JUST Orange Avenue items but want it to automatically pull any and all info from each tab where that person's Ornage Avenue duties are.

View 9 Replies View Related

Data Transfer

May 17, 2007

cells(a,b):cells(a+4,b) have 1,9,9,0,5
cells(a,b+3):clells(a+4,b+3) have 1,9,0,emtpy,empty.
how to fill 9,5 to empty cells.

View 7 Replies View Related

Copyrights 2005-15, All rights reserved