macro code to show userform

hi guys
wondered if someone could give me the macro code
for when i click an image

that says click me

it takes me to the input data userform

thanks

Once you have attached the control that you want to click, you can assign this macro to it:

Please Login or Register  to view this content.

NOTE: userfom1 should be the name of the userform you want to show.

hi big bas

im getting invalid outside procedure

maybe its something to with this???

Public Const conPW As String = "WAREHOUSE"

Where is the problem? The code that I have given you is strictly to show the actual userform. Attach that code to your control.

Are you saying there is a problem within your actual code somewhere else? Can you post the entire code that you are using?

got it to work big bas

what i need the search button to do is :-

if i type a customer name up ie smith

i need it to look on the data worksheet for the name smith and then display all the details for that customer

or indeed the same for job number
ie 2345

is this possible

It definitely sounds plausible.

In matters like this, it is most helpful to post a .zip sample of your worksheet so that we know exactly what you are working with. Also, attach clear details on what you would like to happen.

I know many of us have built database like Excel files with functional search features, so it shouldn't be a problem.

what i should add is that my search userform

has customer name or job number as its search items

but when it finds its target it needs to display

customer name
job number
size
material
qty
code
in or out
date done
booked out?
comments
grey card

is that possible?

i cant attach it bas as its already 255kb

when i compress it
it only goes to 234 is this normal?

superb royuk

many thanks

exactly what i needed

will give it a read and a good go

back later no doubt. . . .

HI ROY

were you the author of that?

do you mind if i try and adapt it for my stuff as it is awesome

and do you mind if i ask a few questions along the way so i can try and understand some of the coding

thanks

superb roy many many thanks

really appreciated

im trying to learn macros and vba but its slow learning without anything to compare to so your offer is greatly appreciated

regards

steve

hi roy

just wondering what this part actually does

Please Login or Register  to view this content.

roy?
please