The application searches for the smallest value in the array

**jacek890** · 05-15-2012, 04:21 PM

Hello
Please help. I have the task of retrieving an application to create smallest value in the array. Its size and components in it determined by the user, and the solution must be on a form, and the result should be saved in a file. Please help, I'm a beginner in VBA and do not really know how to do this work. how to perform a stepwise implementation of the solution. Can someone show how to solve this task?

**jeffreybrown** · 05-15-2012, 04:25 PM

Hello & Welcome to the forum,

Can you be a little more specific? Are we talking about one spreadsheet and what cells, what range etc.?

My first thought, looked at this function =SMALL(array,k)

**jacek890** · 05-15-2012, 04:32 PM

thank you for your interest in this. So it has to be in one sheet on the form. The scope of any because they are determined by user

**jeffreybrown** · 05-15-2012, 04:38 PM

Can you provide a workbook sample of what you have and what you want?

**jacek890** · 05-15-2012, 04:48 PM

I do not have the workbook because it is my job that I got on the sheet. Its exact content is:
Create a search & application smallest value in the array. The size of the array and it contains elements determined by the user. Solution to the problem must be on a form and include a stepwise implementation of the solution. The result should be saved in a file.
The task must be solved in Excel VBA
This is the whole content of the task. Thank you for your interest in my request.

**jeffreybrown** · 05-15-2012, 05:05 PM

I'm sorry but without some type of guidance I am not seeing what you require. Might this actually be some type of school assignment? It sure reads that way.

Well anyway, if you can get a hold of your sample workbook from the job that would help me see your layout and requirements.

If not, then maybe somebody else can step in with some ideas.