littlepete
Well-known Member
- Joined
- Mar 26, 2015
- Messages
- 503
- Office Version
- 365
- Platform
- Windows
Hello
My first userform shows all available data from a person (names, addresses, birth and other data,...)
the button "show text" on that first userform should open a smaller userform on top of the first one,
and put the contents of column F in the active row in it (it is a written full text with all data in it:
i stead of " birth: 19.04.1961" it will say: "... was born on 19 april 1961 in ... "
i have tried button.change ; .initialize ; .text ; .value ; userform .initialize ; ...
I guess the vba can be very short:
showtext.show
dim thisrow as long
ufuserform.pfnaam.Text = Sheets("gegevens").Range("ak" & dezerij).Value
but nothing happens...
after clicking the showtext button on the first userform, it shows the second userform : perfect!
but it does not fill the one and only textbutton to show that text...
as always, the problem is: where should i put the code, and what?
have fun creating !
My first userform shows all available data from a person (names, addresses, birth and other data,...)
the button "show text" on that first userform should open a smaller userform on top of the first one,
and put the contents of column F in the active row in it (it is a written full text with all data in it:
i stead of " birth: 19.04.1961" it will say: "... was born on 19 april 1961 in ... "
i have tried button.change ; .initialize ; .text ; .value ; userform .initialize ; ...
I guess the vba can be very short:
showtext.show
dim thisrow as long
ufuserform.pfnaam.Text = Sheets("gegevens").Range("ak" & dezerij).Value
but nothing happens...
after clicking the showtext button on the first userform, it shows the second userform : perfect!
but it does not fill the one and only textbutton to show that text...
as always, the problem is: where should i put the code, and what?
have fun creating !