VBA Input Box - Multiple Input Values

**hobbiton73** · 12-03-2014, 03:26 AM

Hi, I wonder whether someone may be able to help me please.

I know how to create an 'Input Box' via VBA to allow a user to enter a value which, for example, performs a task which opens and extracts multiple files before amalgamting them into a "Summary " sheet.

But could you tell me please, is it possible to capture multiple values from one 'Input box'?

I've carried out some research on this, but I've been unable to find a suitable thread/tutorial which I could build upon.

I just wondered whether somoene may be able to confirm whether this is possible or not, and if so point me in the direction of a tutorial/guidance which I can use.

Many thanks and kind regards

Chris

**:) Sixthsense :)** · 12-03-2014, 03:39 AM

In the input box fill the file name with a separator like

File1.xls|File2.xls|File3.xls etc.,

Then use

Split(InputboxValue,"Seperator Here")

arFileList = Split(InputboxValue,"|")

arFileList is an array which will hold all the inputted file names.

Now you can loop though the arFileList array and open the files

**hobbiton73** · 12-03-2014, 05:46 AM

Hi @Sixthsense, firstly thank you for taking the time to reply to my post and secondly, my sincere apologies for not providing a poor example because I didn't realise how complex it may be.

The script I'm trying to adapt is as below:

Please Login or Register  to view this content.

I've even been able to get one value to extract the records, but I'm struggling to implement where the user can enter mutliple values.

I hope this helps and my apologies for the lack of clarity.

Many thanks and kind regards

Chris

**:) Sixthsense :)** · 12-03-2014, 06:30 AM

Originally Posted by hobbiton73

I've even been able to get one value to extract the records, but I'm struggling to implement where the user can enter mutliple values.

Which line of code refers to that one value?

The below one?

Please Login or Register  to view this content.

**hobbiton73** · 12-03-2014, 06:46 AM

Hi @Sixthsense, thank you for coming back to me with this.

I can confirm that you are correct in your assumption, the line you highlight is the line which captures the value.

Many thanks and kind regards

Chris

**:) Sixthsense :)** · 12-03-2014, 08:49 AM

I can give you an idea but you have to adjust it for your code

Please Login or Register  to view this content.

**hobbiton73** · 12-03-2014, 09:23 AM

Hi @Sixthsense, thank you very much for this, it works great!

All the best and kind regards

Chris

VBA Input Box - Multiple Input Values

LinkBack

Thread Tools

Rate This Thread

Display

VBA Input Box - Multiple Input Values

Re: VBA Input Box - Multiple Input Values

Re: VBA Input Box - Multiple Input Values

Re: VBA Input Box - Multiple Input Values

Re: VBA Input Box - Multiple Input Values

Re: VBA Input Box - Multiple Input Values

Re: VBA Input Box - Multiple Input Values

Thread Information

Users Browsing this Thread

Similar Threads

input values to effect total, then rest input to zero

Returning multiple values in multiple cells based upon one input

Input multiple data into one input field (VBA)

is it possibel to have multiple input values in one cell?

Calculate multiple results from multiple input values?

Bookmarks

Bookmarks

Posting Permissions