Macro Problem

[#1]

Hi

i have a problem.I have taken a textobject on the sheet .but i wana apply text to that text object through

macros.what i want is when i click on the button ,the text should appear on the textobject before this event ,

the textbox should be empty?Can we use a button click event in macros?If yes then how?

Regards

Sikandar

[#2]

Hi,

From where do u want to input the data to text box while clicking the button...?

- Sridhar

[#3]

Hi,

I`m not clear about your query, But still you dnt want to go for macro`s.

Use input box to enter data and use the same variable to display the data in textbox.

If you could explain your scenario clearly, i would be easy for us to suggest some thing...

- Sridhar

[Anonymous]

Sikandar,
What do you mean "Can we use a button click event in macro?" If you want to call a macro by clicking a button just make this button a macro button. Or, am I missing what's the question about?

[#5]

Hi

I have attached a QVD file.plz look it and and help me finding the solution

Regards

Sikandar

[rwunderlich · Accepted solution]

Remove the "if (BU01_Click) then" from your macro. There is no BU01_Click to test. Your macro is attached to the button, and will only get called when the button is clicked.

-Rob

[#7]

Hi Rob

Can u plz update my code and send me the QVD as it will be very helpfull for me....

Thanx

Regards

Sikandar

[#8]

Hi

I have resloved this issue.i was doing a very simple mistake...

Regards

Sikandar

[#9]

HI Sikand,

In your attachment in macro just comment that if statement,then u will get the result.

Regard,

Ravi kumar.