Pass Input-box String From Sub To Main

Oct 23, 2013

how to specify a file extension type for a browseforfolder part of what i've been doing.

It's not calling correctly as i'm not sure how to feed the inputData string back into the main.

Obviously there's probably better ways of doing this, but can my way be corrected easily?

I've been looking into ByVal and ByRef, but have only seen examples goin from main to the sub and not the other way.

Code:
Sub Main()
Dim strFolderName As String
Dim strFolderTest As String
Dim FRCntrHiLim As Variant
MsgBox "before calling inputbox"
Call InputBoxTest(inputData) '

View 4 Replies


ADVERTISEMENT

Input Box To Pass Text To Cell?

Dec 31, 2013

I have the below code which creates a new template

Code:
Private Sub NewTemplate_Click()
Dim Tsh As Worksheet
Set Tsh = Sheets("TEMPLATE")
Tsh.Copy After:=Sheets(Sheets.Count)
shName = InputBox("Please enter new sheet name:")
ActiveSheet.Name = shName
Tsh.Visible = False
End Sub

What I would like to add to the above code is two more inputbox prompts, the first should prompt the user for a Name (text and length) to go into the new sheet cell A6. The the second input box should as for code, (number any length), to go into the new sheet cell b6.

View 3 Replies View Related

Excel 2003 :: How To Pass A Parameter In The Input Range

Mar 21, 2014

I have a combobox in a excell sheet. It is possible to pass a parameter in the input range instead of Parm!$B$1:$B$10

View 2 Replies View Related

Pass String To ParamArray?

Jul 3, 2014

I am trying to pass a string to a function requiring a ParamArray. See below

Code:
Declare Function LibFunc1 Lib "FuncAddin" (ByVal vtSheetName, ParamArray Mylist() As Variant) As Long
Sub testsub()
Year = 2013
Period = December
MyStr = "Year#" & MyYear & """", "Period#" & MyPeriod & """"

LibFunc1("Sheet1", MyStr) 'how to declare string so it can be passed as ParaArray?

End Sub

View 1 Replies View Related

Pass Filename To String Variable

Aug 3, 2006

Have a file lets say is named

sample.xls

Does anyone know how to retrieve the name of the file in VB?

just the name and put it in a string?

View 3 Replies View Related

Pass String Variable To Userform Using Property Procedures

May 29, 2013

I want to display a string to users. Normally I would do that using message boxes. But that would not give me enough control over the font size, and I want to display using font size 48.

I could have used global variables, but that is not a good coding way. The other way of doing that is using property procedures. I could pass a string variable to a Label control on the form and then could format it.

View 9 Replies View Related

Search For Decimal And When Found Pass Row Number To Rest Of String?

Feb 12, 2014

I am trying to search through column "I" for numbers that are decimals, when the first decimal is found, use the row number that the first decimal appears in the string that populates the bookmarks stored in a word template I have created. The code I have so far checks for the decimal and then populates the bookmarks, however it requires me to input the ranges manually, meaning I can set them as the first row in my tabel. But if the decimal appears in the second row and not the first I'm bookmarking the wrong data. Here is the code I have so far;

[Code] ........

View 3 Replies View Related

VBA / Using String From Input Box As Criteria For CountIF

Aug 19, 2014

I'm trying to enter text (a staff members initials) into an Input Box so that the initials are then used as the citeria in a CountIF formula entered by VBA

A simplified version of the code I am using is:

Dim staffname As String
staffname = InputBox(Prompt:="You name please.", _
Title:="ENTER INITIALS", Default:="MC")
Range("H9").FormulaR1C1 = "=COUNTIF(RC[-3]:RC[-1],"" & staffname & "")"

The issue is getting the staffname string to be entered within the formula.

What is the correct combination of "" & to enable this to work?

View 6 Replies View Related

Including Column A String Into Input Box

Feb 24, 2009

I have a code of;

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Set Target = Me.Range("c4:f100")
Dim iSold As Long, iColumn As Integer
Dim strTitle As String
If Intersect(ActiveCell, Target) Is Nothing Then Exit Sub
iColumn = ActiveCell.Column
Select Case iColumn
Case 3

An what i need to happen id the input box saying "Please enter quantity of (whatever is in cell A11) assuming i am clicking on E11

so in other words, in cell A11 it says "MONITOR", i need the input box to pop up and say "Please enter quantity of MONITOR "

View 9 Replies View Related

Display Decimal Value Input As String Format

Aug 16, 2012

I'm writing a macro that will automatically change the display in a column of cells.

The input in the cell would be a decimal value, (e.g. 1, 1.25, 1.5, 1.75, 2). As of now, I think the only input options are whole numbers and 1/4, 1/2, 3/4 fractions.

After inputting the decimal value, the cell should update to display the value as the following string format :

Input: 1.25
Displays: 1-1/4"

The purpose being to enable fast data entry while displaying in the desired format.

Here is where I know to begin for the automatic update:

Code:

Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
'
'
'Code
'
'
Application.EnableEvents = True
End Sub

View 6 Replies View Related

Auto Generation Of String Based On User Input

Jun 3, 2009

Without using VBA, how can i generate strings say

x1
x2
x3
x4
x5

assuming user has inputed two numbers 1 and 5. I know you might have lots of questions like how the hell user input is coming when there is no usage of VBA.

View 3 Replies View Related

VBA For Inserting Input String Alphabetically Into Column Of Names?

Oct 2, 2013

I have a list of names in the A column of the sheet. I wish to use the input string, a new name, of a vba box to insert into the column of existing names in alphabetical order by inserting an entire row, which I suspect will be the case anyway. Also 'Return' key doesn't seem to be inserting a CR on the page that I typed this request upon.

View 5 Replies View Related

Function To Process String Input And Return Integer

Oct 2, 2006

i did some VBA quite a while back, and picking it up again.

I'm trying to get a function to read in a string, and return a value based on the string value.


Public Function value(ItemType As String) As Integer
If ItemType = " Upper" Then
value = 40
ElseIf ItemType = "Middle" Then
value = 50
ElseIf ItemType = "Lower" Then
value = 25
End If
End Function

When i tried using it at the Cell level, it keep giving error i.e. Invalid Name Error

View 9 Replies View Related

How To Change Variable Data Type To String If User Input Is Not A Number

Jun 3, 2014

I have declared a 'long' variable. however; how do I change the variable data type to string if user input is not a number? how do I recognize the user input's datatype?

View 7 Replies View Related

How To Get The Result From Main Sheet

Aug 14, 2014

In my attached sheet.. I want the result from data sheet.. I have to enter the batch no and pallete no.. then all the data have to display in result sheet

View 2 Replies View Related

Code To End A Main Sub Before End Sub Point

Jul 11, 2009

I’m using this code to run consecutive programs, which works really well, apart from one little glitch.

View 3 Replies View Related

Hide Application Main Bar

May 27, 2006

how to hide the main bar from Excel? the one where says "Microsoft Excel - "Name of the workbook"

View 9 Replies View Related

Access To Pop-up Main In Sheet

Nov 6, 2009

I created a popup menu when you click the right mouse bhutan .. ok?

Now I would like to access the pop-up Main excel, where you click with the right mouse button and appears Cut, Copy.

then I would like to add a new a item in this pop-up

View 9 Replies View Related

Summary Of Cells On Main Sheet

Dec 13, 2008

I have Sheet 1 that does some calulations and will Output my values e.g.

1X2X
44XX
3XX1

there are also - - - - in the cells for some cells that does not meet my calculations..

So now i have a bunch of - - - - and 1X2X numbers inside sheet1.

Now what i want is to display a Summary of my Cells in the MAIN sheet. just the cells which contains values like 1X2X only.

View 6 Replies View Related

Taking Row Of Spreadsheet And Putting Into Main One

Nov 29, 2013

I have a bunch of spreadsheets in a folder and I need to take one line of each spreadsheet (which is in the same place on every one) into a master spreadsheet.

I am always adding to the spreadsheets in the folder.

Is there a way to have my master spreadsheet look out for changes in the folder and when there are changes add the row into it?

View 2 Replies View Related

Shortcut To Copy To Main File

Feb 20, 2008

I receive everyday 100 excel sheets contaning data out of which i have to copy only 4 cells- amount, name, invoice number, vendor name into the master excel sheet. So i every time one all the excel sheet one by one and copy particular cells- e3, h45, l9,x0 and paste them one by one in the master file which i had mainted to treack the invoices issued.

Is there any shortcut where as i can minimize my copy paste work and click a button after opening each file- which i think i have to do as there can be no shortcut to it, and the 4 cells can be copied to my master file.

View 9 Replies View Related

Close All Workbooks Except For The Main Workbook

Jan 5, 2009

Is there anyway to change the following code so that it will save and close all workbooks except the one that has this code?

View 3 Replies View Related

Copying Data From Main Worksheet To Another

Apr 11, 2012

I have a main spreadsheet that lists all the members and profile URLs for members in a forum. In Sheet 1, Column A is the username and Column B is their profile URL.

In sheet 2 I have a list of the members who are in listed in a particular category in the forum. However, I don't have the profile URL data. What I want to do is create a macro that look in Sheet 1 for the username and if profile URL is thier, copies that into sheet 2 next to the appropriate username.

View 1 Replies View Related

Copy To Main Worksheet From Many Worksheets

Aug 7, 2006

I went through your board and found the code below posted My Mr. Tom Urtis.
I tired it and it worked fine except that it needs another workbook.
Can it be changed to work in the same workbook to copy to a sheet named as Main from all other worksheets that I can chose?

Sub ImportDistricts()
'Instructional Message Box
MsgBox "Click OK to access the Open dialog." & vbCrLf & _
"Navigate to the folder path that contains" & vbCrLf & _
"the District workbooks you want to import." & vbCrLf & vbCrLf & _
"When you get inside that folder path," & vbCrLf & _
"use your mouse to select one workbook," & vbCrLf & _
"or use the Ctrl button with your mouse" & vbCrLf & _
"to select as many District workbooks" & vbCrLf & _
"as you want from that same folder path." & vbCrLf & vbCrLf & _ ....................

View 9 Replies View Related

TOC: Main Menu Column Insertion

Sep 24, 2008

I've been using this code to make menus for all my Excel sheets since NateO made it back in 2003.

- The workbook has 370 sheets, 365 of them are one day per month with the tab named ddmmmyy.
- The Main Menu in this file puts the months Jan, Feb, Mar, etc in cells A3:L3.
- In the single cells under each month it put the month day tab name (ddmmmyy) and hyperlinks it to the sheet tab.

I would like to do two new things.
1. Put the name of the month in everyother cell in row 2, so Jan would be in A2, Feb in C2 and Mar in E2, etc.
2. Put the day of the week for each date in the cell to the right of the date. So the column heading would be Jan in A2, 01Jan08 in A3 and Tue in B3.

I thought I could make another macro and just insert the rows after the Main Menu was built and then VBA copy/paste TEXT(cell,"ddd") down the ranges, but thought there might be a better idea out there...

Sub Workbook_TOC()
Dim ws As Worksheet
Dim wsNw As Worksheet
Dim z As Integer

View 9 Replies View Related

Userform As A Standalone Vb Main Interface

Oct 17, 2006

In order to beutify my prog's interface, i would like to open the Excel file(active VBA) with the worksheet in the minimized background or hide, i.e. only the Userform or a Dialog window, from the right beginning on! as if it was a standalone VB main interface.

View 3 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:

=(NUM1*(NUM2*$H10))/$H10

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







Copyrights 2005-15 www.BigResource.com, All rights reserved