trying to change a txtbx in module

I have a project with many forms and textboxes. I am trying to create a module that will add a "." (Chr45) in the value.

this is the code on the userform. the textbox name changes throughout the project

Please Login or Register  to view this content.

this is what i have in the module. I suspect it has to do with knowing the actual name of the textbox?
the code below is not working, could anyone help?

Please Login or Register  to view this content.

it is a basic code i am just starting to work with. I will be expanding the code as soon as i figure out this simple task

Hi

One option is to pass in a parameter to your sub which tells the TxtBx_Change routine which textbox to run code against - this will have the added benefit of making the routine reusable for each textbox:

Please Login or Register  to view this content.

Richard

Originally Posted by Zygoid

i am getting an error on that line in the event

"sub or function not defined"

Where have you defined the TxtBx_Change sub? If it is in a separate module to the Userform then you need to remove the Private keyword from the start of the sub name.

Originally Posted by Zygoid

the userform and module are in the same project. is that what you mean?

If they are in separate modules (and it sounds like they are) then you need to remove the Private keyword from the Sub name (just of TxtBx_Change, not the TextBox4_Exit routine).

Can you post the full code you are using. Also, if in a standard module, can you change the sub declaration to:

Please Login or Register  to view this content.

Hello Zygoid,

Place this macro in a standard module and then add calls to each of the TextBox_Exit events.

Main Macro

Please Login or Register  to view this content.

TextBox Exit Code

Please Login or Register  to view this content.

Sincerely,
Leith Ross

You could alternatively just hook into another event to check all the text box values at the same time? Eg if the user subsequently needs to hit a command button to submit the form's contents then you could use the button's click event to execute a loop which runs thru all the textboxes on the userform and checks & amends the values as appropriate.

Please could you post the current sub header of the procedure TxtBx_Change.

Richard