The images below explain in much less words I can describe. When a user first clicks on this apps combobox(or whatever
this control is, the following occurs in sequence:
1. A
or userform(or whatever this control is) list automatically drops down giving the user a book choice to click on
2. Once a book choice click is made, another smaller userform[table?] drops down giving the user a chapter choice to then select
3. Once book and chapter choices are made(and stored in memory ), a third smaller userform list drops down
giving the user a choice to select a verse. Each selection is stored in memory.
Once a button is clicked, the FIND method should go right to the Book chapter and verse and display that result in a userform textbox i.e. --> Matthew 24:15.
I tried this with a userform and Labels and the image MYTRY below. My initial thoughts is that that its crude and mundane with labels
and I really don't want to invest new time in a learning curve with something like Visual Studio or some other app that is better designed for this - but if I have to, I will.
Userform code:
Next steps would be to add code to open two other userforms, one after the other as an itme on each is clicked,
and replicate what the app images does below. T he beauty of all this is it involves NO TYPING AT ALL. Only successive mouseclicks.
I really need a higher level of experience help on this to accomplish what I have described. Please someone, reach out to me
and help if you can.
Many thanks and much appreciated.
cr
this control is, the following occurs in sequence:
1. A
2. Once a book choice click is made, another smaller userform[table?] drops down giving the user a chapter choice to then select
3. Once book and chapter choices are made(and stored in memory ), a third smaller userform list drops down
giving the user a choice to select a verse. Each selection is stored in memory.
Once a button is clicked, the FIND method should go right to the Book chapter and verse and display that result in a userform textbox i.e. --> Matthew 24:15.
I tried this with a userform and Labels and the image MYTRY below. My initial thoughts is that that its crude and mundane with labels
and I really don't want to invest new time in a learning curve with something like Visual Studio or some other app that is better designed for this - but if I have to, I will.
Userform code:
Code:
Private Sub UserForm_Initialize()
Me.Top = 10
Me.Left = 5
End Sub
Private Sub ZECH_Click()
ZECH.BackColor = RGB(0, 200, 255)
Sheets("BIBLETEXT").TextBox1.Value = "Zechariah"
Sheets("BIBLETEXT").TextBox2.Value = "Zechariah"
End Sub
and replicate what the app images does below. T he beauty of all this is it involves NO TYPING AT ALL. Only successive mouseclicks.
I really need a higher level of experience help on this to accomplish what I have described. Please someone, reach out to me
and help if you can.
Many thanks and much appreciated.
cr