Torstein, To expand somewhat on what Lisa wrote, I've included code for the loop that adds some user conveniences, such as clearing the textbox and refocusing the cursor to the textbox. Sub trythis() Dim i As Integer Dim TheEntry As String For i = 1 To 25 UserForm1.Show TheEntry = UserForm1.TextBox1.Text UserForm1.TextBox1.Text = "" 'need to clear the textbox after you've captured the entry UserForm1.TextBox1.SetFocus 'puts the focus back in the textbox Next i End Sub Dave Gathmann --- In ExcelVBA@yahoogroups.com, Torstein Johnsen <sejohnse@...> wrote: > > i have a loop with an inputbox > >...
Minggu, 30 Juni 2013
[ExcelVBA] ReDux: I'd like a Before_UserForm_Terminate Event
FYI: Looking at another problem, I reviewed the MsgBox section of my Handy-Dandy personal VBA Hints document to find that the Terminate [x] can be disbled and the button values captured to provide feedback of the implications of the user's choice... (by proper selection of the MsgBox Button style number). Ya just never know whre you'll find what you're looking for. Regards, Steve --- "noskosteve" wrote: > > > Thanks for the suggestions, but if I really want to confirm what the [x] does, another MsgBox is pretty simple. > > Resetting parameters for the Label and the original UserForm doesn't appear to work inside the Terminate Sub. Enough time spent on a minor...
Re: [ExcelVBA] loop with userform
Torstein, You close the form... and thus return to the calling code... with ... Unload Me ... in the form code. But.... hehehe... you probably want to return what's been typed in to the calling code code and guess what... Userforms don't return anything. And of course there are ways to do this. The cleanest way IMHO is to Hide the form instead of unloading it. The forms objects are still available and their values can be picked up. Assuming a form called UserForm1 with a textbox called TextBox1 and a button called CommandButton1 ... In the calling code.... UserForm1.Show MsgBox UserForm1.TextBox1.Text Unload UserForm1 In the Click event for the Command button... Me.Hide...
[ExcelVBA] Re: Sheet CommandButton becomes "crosshatched" and comatose.
And the winner is ... Ralph wins the Kewpie doll. Activating the active cell (seems like an oxymoron) before changing sheets did the trick. Regards, Steve also spelt: cupie, kewpee Yes, that was intentional... --- "Ralph Gregory" wrote: > > Yes .realised after I sent it ...:-( seems the button press action is left active when sheet changes .could selecting a cell on the sheet before switching active sheet help > > Regards Ralph > > ----- Reply message ----- > From: "noskosteve" <noskosteve@...> > > Date: Sat, Jun 29, 2013 1:55 am > I guess you misssed it. That's what is there. See end of this post for the code. > > Steve...
[ExcelVBA] Re: Sheet CommandButton becomes "crosshatched" and comatose.
OOPS! Excel 2007. I try to remember to include that... Steve --- Tim Lewis wrote: > > Which version of Excel are you using? > > From: noskosteve > Sent: Saturday, June 29, 2013 12:46 AM > > More interesting schitck...and solution, sort of... > > I noticed that the crosshatching was slightly different via CommandButton Object>Edit. > > I moved the CommandButton down to get a better look at the difference and realized that I had frozen the pane with just the top row frozen at the top and this CommandButton was in the frozen top row. The visible difference was aparently due to the button size/border interferring a bit with the frozen pane...
[belajar-excel] Digest Number 2393
Milis Belajar Microsoft Excel Group 3 New Messages Digest #2393 1a Re: irisan by "Mr. Kid" nmkid.family@ymail.com 1b Re: irisan by "Robby...
Langganan:
Postingan (Atom)