Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MultiPage Form Question
How do I pass values from one textbox from the 1st tab to the 2nd tab? For
example: me.textbox1 is on the 1st tab and has a value of 1234. On the 2nd tab of the multipage form, me.textbox2 is empty. I tried this the code below and it didn't work. me.textbox2.value = me.textbox1.value Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MultiPage Form Question
Hi,
The below code added to TextBox1 does reflect changes made and shows in TextBox2 HTHs Rob Sub TextBox1_Change() Me.TextBox2.Value = Me.TextBox1.Value End Sub "NFL" wrote in message ... How do I pass values from one textbox from the 1st tab to the 2nd tab? For example: me.textbox1 is on the 1st tab and has a value of 1234. On the 2nd tab of the multipage form, me.textbox2 is empty. I tried this the code below and it didn't work. me.textbox2.value = me.textbox1.value Thank you! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
MultiPage Form Question
You're right... it does work. The value will only appear when a keystroke
is made on that field. Is there a way to have the value appear without placing a cursor and typing a keystroke? "Rob" wrote: Hi, The below code added to TextBox1 does reflect changes made and shows in TextBox2 HTHs Rob Sub TextBox1_Change() Me.TextBox2.Value = Me.TextBox1.Value End Sub "NFL" wrote in message ... How do I pass values from one textbox from the 1st tab to the 2nd tab? For example: me.textbox1 is on the 1st tab and has a value of 1234. On the 2nd tab of the multipage form, me.textbox2 is empty. I tried this the code below and it didn't work. me.textbox2.value = me.textbox1.value Thank you! . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
MultiPage Form Question
You'll need an event triggered to run code to transfer the contents from one
textbox to another, there are a few options including when the form shows. HTHs, Rob "NFL" wrote in message ... You're right... it does work. The value will only appear when a keystroke is made on that field. Is there a way to have the value appear without placing a cursor and typing a keystroke? "Rob" wrote: Hi, The below code added to TextBox1 does reflect changes made and shows in TextBox2 HTHs Rob Sub TextBox1_Change() Me.TextBox2.Value = Me.TextBox1.Value End Sub "NFL" wrote in message ... How do I pass values from one textbox from the 1st tab to the 2nd tab? For example: me.textbox1 is on the 1st tab and has a value of 1234. On the 2nd tab of the multipage form, me.textbox2 is empty. I tried this the code below and it didn't work. me.textbox2.value = me.textbox1.value Thank you! . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
MultiPage Form Question
I'm not sure how to do this. Can you show me how to do this and where would
the code be placed? "Rob" wrote: You'll need an event triggered to run code to transfer the contents from one textbox to another, there are a few options including when the form shows. HTHs, Rob "NFL" wrote in message ... You're right... it does work. The value will only appear when a keystroke is made on that field. Is there a way to have the value appear without placing a cursor and typing a keystroke? "Rob" wrote: Hi, The below code added to TextBox1 does reflect changes made and shows in TextBox2 HTHs Rob Sub TextBox1_Change() Me.TextBox2.Value = Me.TextBox1.Value End Sub "NFL" wrote in message ... How do I pass values from one textbox from the 1st tab to the 2nd tab? For example: me.textbox1 is on the 1st tab and has a value of 1234. On the 2nd tab of the multipage form, me.textbox2 is empty. I tried this the code below and it didn't work. me.textbox2.value = me.textbox1.value Thank you! . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multipage tab question | Excel Discussion (Misc queries) | |||
MultiPage tab? | Excel Discussion (Misc queries) | |||
MultiPage control | Excel Worksheet Functions | |||
MultiPage | Excel Discussion (Misc queries) | |||
How do I use multipage | Excel Discussion (Misc queries) |