Live-Forum - Die aktuellen Beiträge
Datum
Titel
28.03.2024 21:12:36
28.03.2024 18:31:49
Anzeige
Archiv - Navigation
248to252
Aktuelles Verzeichnis
Verzeichnis Index
Übersicht Verzeichnisse
Vorheriger Thread
Rückwärts Blättern
Nächster Thread
Vorwärts blättern
Anzeige
HERBERS
Excel-Forum (Archiv)
20+ Jahre Excel-Kompetenz: Von Anwendern, für Anwender
248to252
248to252
Aktuelles Verzeichnis
Verzeichnis Index
Verzeichnis Index
Übersicht Verzeichnisse
Inhaltsverzeichnis

looping Userforms

looping Userforms
30.04.2003 13:42:13
Carmen
I have several uswerforms set up due to the variation of what I want to display for each userform....my goal is to loop these userforms one at a time while accepting inpüut from each userform. at the end of the series, begin the loop again while storing the answers in an Excel DB.

Is this possible and if so how?

2
Beiträge zum Forumthread
Beiträge zu diesem Forumthread

Betreff
Datum
Anwender
Anzeige
Re: looping Userforms
30.04.2003 13:52:35
ChrisL

Dear Carmen

I don't quite get it. Should the UF Loop be automatic or triggered by CommandButton? If automatic how can anybody make inputs. If by CommandButton, why don't just Link the UF's by Button, like

Load UF1
UF1.Show

Unload UF1
Load UF2
UF2.Show

Unload UF2
Load UF3
UF3.Show

Unload UF3
Load UF1
UF1.Show

Regards,
Chris

Re: looping Userforms
30.04.2003 14:02:34
Nike

Hi,
I`m pretty sure this is possible.
Just write the results into certain Cells and
read them from these cells, when opening the next userform.

e.g.
Private Sub CommandButton1_Click()
Range("A1").Value = TextBox1.Text
End Sub

Private Sub UserForm_Initialize()
TextBox1.Text = Range("A1").Value
End Sub

Bye

Nike

Anzeige

Beliebteste Forumthreads (12 Monate)

Anzeige

Beliebteste Forumthreads (12 Monate)

Anzeige
Anzeige
Anzeige