bring a selected record into a form

[ntambomvu]

Hello Everyone--

Hope you dont mind stupid questions-- but please help if you can

I have a spreadsheet of customers
If i want to capture new details i use the search function which enables me
to select the customer i want from a filtered criteria.
Now i want to get the record that i have selected into a form
I click on the "form" tab and the form opens
how do i get the selected record into the form.
It always displays the first record in the spreadsheel
and not the one I have selected??
regards from South africa
fred

[NeedForExcel]

On your form, assuming its a Text Box, can you not assign the value of the activecell to the textbox?

[HaHoBe]

Hi, ntambomvu,

you should consider to arttach a sample of your workbook for better understanding (with the code you have so far). Or you may have a lok at An Excel DatabaseForm to adapt for your own projects as an example how to solve the problem.

Ciao,
Holger

[ntambomvu]

Thanks chaps-- I am new to this thing
I just used the excel form that is on the ribbon
Where do I find the file which I must attach and what will it be called??
( I mean what extension must i look for
Secondly What does it mean to assign a value to the active cell??

thanks

[HaHoBe]

Hi, ntambomvu,

AFAIR there is no Form on the Ribbon in Excel2013 (at léast not in my local version of it) except that the DataForm has been activated via the options. And if so there will be no VBA Code or workbook as that is a feature integrated into Excel.

Ciao,
Holger

[ntambomvu]

Hello Holger
on the home tab extreme right-- I have developer activated

regards

fred