Minggu, 30 Juni 2013

[ExcelVBA] Re: loop with userform

 

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
>
> for i = 1 to 25
>
> svar = inputbox("answer?")
>
> next i
>
> I want to replace the inputbox with an userform, which I'm not familiar with.
>
> How can I return from the userform to the loop when the user has written his answer?
>
> Thank you!
>
> Regards
>
> Torstein
>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
.

__,_._,___
READ MORE....

[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 feature.
> Regards, Steve
>
>
> --- In ExcelVBA@yahoogroups.com, "noskosteve" <noskosteve@> wrote:
> >
> >
> >
> > --- David Grugeon wrote:
> > > Hi Steve.
> > > Only been half following this one so excuse silly suggestion.
> > >
> > > One of the actions the terminate will take is to close the form, so could you do your stuff on the beforeClose event of the form? You may need to either cancel event, then recreate it after you had finished your stuff, or find another way of pausing the terminate until the required label had been seen.
> > > Regards, David Grugeon
> >
> > Stream of thoughts follows...
> >
> > Hmmmm Maybe only half-silly... Remember;
> > 1 - I want to click the [x] and have a confirmation message say "Changes Cancelled", or Discarded". The [x] causes the Terminate Event (as I understand what I see happen), not a BeforeClose Event (hence my Subj).
> >
> > B - MSDN says all elements of a form have ALREADY been set to NULL BEFORE the Terminate event occurs (before the Terminate Sub is even entered).
> >
> > I did try RE-"Showing" the form in the Terminate sub thinking it would reinitialize everything in the form, but it hung up somehow and I dropped that.
> > HOWEVER...
> > Perhaps, just perhaps, I can reinitialize (re-define) my label/message myself rather than just setting it to visible.... If it is Null (but still there) and I make it visible, I still see nothing(Null). However, If VBA will let me re-define the label inside the Terminate Sub, that may just work...
> >
> > In other words, something like this:
> > Private Sub UserForm_Terminate()
> >
> > Me.Label1.Value = "Changes Canceled"
> > Wait (40) ' My own wait routine.
> >
> > End Sub ' Form disappears from screen here.
> > ------
> >
> > I may have to set the location and other parameters, but this sounds simpler than re-doing the Title Bar and [x]. Worth a try.
> > Though, having the ability to do my own Title Bar has interesting future possibilities... );-E
> >
> > BTW:
> > I just tried entering a: Private Sub Userform_beforeclose()...no deal.
> >
> >
> > Thanks for the nudge...
> > I'll report results if any.
> > Steve
> >
> >
> > > On 21 June 2013 09:40, noskosteve <noskosteve@> wrote:
> > >
> > > >
> > > > WithEvents doesn't produce anything in the Object Browser (Excel 2007).
> > > > Entering it into the Immediate window produces an error:
> > > > "/!\ Compile error: Expected: line number or statement or end of
> > > > statement".
> > > >
> > > > May take some fiddling to understand.
> > > >
> > > > This is just something that 'would be nice' to have...
> > > >
> > > > Perhaps it "was" an honorable goal.... (;-)
> > > > Thanks.
> > > > Regards, Steve
> > > >
> > > >
> > > >
> > > > --- In ExcelVBA@yahoogroups.com, Green <1z@> wrote:
> > > > >
> > > > > Hi Steve,
> > > > >
> > > > >
> > > > > AFAIK Userform modules are a sort of class module and you can add events
> > > > to them.
> > > > >
> > > > >
> > > > > Check out the WithEvents keyword.
> > > > >
> > > > >
> > > > > I don't know how useful this is so please don't shout at me! hehehe
> > > > >
> > > > >
> > > > > HTH
> > > > > Lisa
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Sent: Wed, Jun 19, 2013 4:31 am
> > > > >
> > > > > Subject: [ExcelVBA] I'd like a Before_UserForm_Terminate Event
> > > > >
> > > > >
> > > > > Excel 2007
> > > > >
> > > > > Unless one of you has a work around, I'll just move on.
> > > > >
> > > > > I have a UserForm (Name is "PortSetup") that asks for some setup items
> > > > (ports,
> > > > > baud rates & stuff). It opens with the previously used values.
> > > > >
> > > > > When the Save button is clicked I show a short verification message
> > > > ("Changes
> > > > > Accepted" - this is a Label I make visible).
> > > > >
> > > > > When the Cancel button is clicked I show another Label on the Form
> > > > ("Changes
> > > > > Canceled" - Label Name is ChangesCancel).
> > > > >
> > > > > The above all work fine.
> > > > >
> > > > > I would also like to show the Cancel verification message when the [x]
> > > > > Terminate box is clicked, but it won't show (visible = True) when I have
> > > > the
> > > > > code located in the UserForm_Terminate() Subroutine. The form still is
> > > > showing,
> > > > > and other things happen, but not the Label Visible...(Google is your
> > > > friend: see
> > > > > MSDN below)
> > > > >
> > > > > The UserForm_Deactivate() doesn't fire either.
> > > > >
> > > > > MSDN says: The Terminate Event "Occurs when all references to an
> > > > instance of
> > > > > an object are removed from memory by setting all variables that refer to
> > > > the
> > > > > object to Nothing..." AND...
> > > > > "The Terminate event occurs after the object is unloaded. "
> > > > >
> > > > > ... AFTER...bummer...
> > > > >
> > > > > Pinging the Object Browser for "Before" shows no BeforeTerminate.
> > > > >
> > > > > Looks like this is a nice idea only... Eh?
> > > > >
> > > > > Regards, Steve
> > > > >
> > > > > Code, FWIW:
> > > > > This works:
> > > > > ------------- The working Cancel Button Event -----------------
> > > > > Private Sub SetupCancel_Click()
> > > > > Debug.Print "****** Setup Form Canceled ******"
> > > > > ' Show verification then hide it.
> > > > > Me.ChangesCancel.Visible = True ' Show it
> > > > > Me.Repaint
> > > > > Wait (40) ' Wait a bit
> > > > > Me.ChangesCancel.Visible = False ' Kill it
> > > > > Me.Repaint
> > > > > Wait (5)
> > > > >
> > > > > ActiveCell.Activate
> > > > > PortSetup.Hide ' Back to Kansas
> > > > > End Sub
> > > > > ----- Terminate [x] DOES NOT work (as expected, I guess...)-----
> > > > > Private Sub UserForm_Terminate()
> > > > > Debug.Print "****** Setup Form Terminated ******"
> > > > > ' The above line shows in the Immediate Window when [x] is clicked.
> > > > >
> > > > > Me.ChangesCancel.Visible = True ' This doesn't show on the Form!
> > > > > Me.Repaint
> > > > > Wait (40) ' This Wait Sub executes.
> > > > > Me.ChangesCancel.Visible = False
> > > > > Me.Repaint
> > > > > Wait (5) ' This Wait Sub also Executes.
> > > > >
> > > > > ActiveCell.Activate
> > > > > PortSetup.Hide
> > > > > End Sub
> > > > > -------------------------------------
> > > > > [EOF]
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > ----------------------------------
> > > > Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
> > > > here: http://www.mousetrax.com/techtrax to enter the ezine, then search
> > > > the ARCHIVES for EXCEL VBA.
> > > >
> > > > ----------------------------------
> > > > Visit our ExcelVBA group home page for more info and support files:
> > > > http://groups.yahoo.com/group/ExcelVBA
> > > >
> > > > ----------------------------------
> > > > More free tutorials and resources available at:
> > > > http://www.mousetrax.com
> > > >
> > > > ----------------------------------Yahoo! Groups Links
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (11)
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
.

__,_._,___
READ MORE....

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

Clicking the command button will hide the form and return to the calling code.

HTH
Lisa

Sent: Sun, Jun 30, 2013 8:56 am

Subject: [ExcelVBA] loop with userform

i have a loop with an inputbox

for i = 1 to 25

svar = inputbox("answer?")

next i

I want to replace the inputbox with an userform, which I'm not familiar with.

How can I return from the userform to the loop when the user has written his
answer?

Thank you!

Regards

Torstein

[Non-text portions of this message have been removed]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
.

__,_._,___
READ MORE....

[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
>
>
>
> --- In ExcelVBA@yahoogroups.com, Ralph <ralph.gregory@> wrote:
>
> >
>
> > What happens if you put in exit sub after activate sheet 3
>
> >
>
> > Regards, Ralph
>
> >
>
> > noskosteve <noskosteve@> wrote:
>
> > >Maybe I should just take up knitting.
>
> > >
>
> > >Famous last words: Everything worked fine until...
>
> > >
>
> > >I have a Sheet1.CommandButton that normally brings up a UserForm for some preferences to be entered/changed by the user and works fine.
>
> > >
>
> > >I added a function which does not need these prefs. It's just a checkBox on Sheet3. When that function is activated, I bring up a message box indicating that the function must be disabled (unchecked) to see the Prefs' UserForm. Then, I exit the CommandButton_Click Sub without Showing the UserForm. Life is still good.
>
> > >
>
> > >Being the nice guy that I am, I figured it would be helpful to also automaticlly activate sheet3 which has the checkBox, so the user can easily un-check it and go back and see the UserForm to enter these prefs.
>
> > >
>
> > >Simply adding the Sheet3.Activate, causes the Sheet1.CommandButton to become crosshatched (when I reselect sheet1) in otder to to click it and enter the prefs.
>
> > >It is full of diagonal lines and unresponsive.
>
> > >
>
> > >When clicking the 'crossed-out' CommandButton, the crosshatch goes away, but it is now non-responsive. The Click Event does not fire the Click Sub.
>
> > >VBA doesn't appear to be paused or haulted in any way - other things work normally.
>
> > >
>
> > >Doing just about anything else that causes some other VBA code to execute then re-activates this catatonic CommandButton.
>
> > >
>
> > >Clicking the Reset button in the VBA window does not awaken the comatose CommandButton, nor change the title bar indicating VBA has changed modes (like going out of debug mode)
>
> > >
>
> FWIW here's the Click sub with the problem (near the end):
>
> ----------------------------------------------
>
> Private Sub PrefsButton_Click() ' Put filter prefs into Form
>
> Debug.Print "S_1 2 Filter Prefs Button Clicked. ";
>
>
>
> 'This sub is in Sheet1.
>
>
>
> 'Look at the ELSE for where the 'crosshatch' problem occurs...
>
>
>
> If Sheet3.Select_2000 Then ' The new function's CheckBox.
>
>
>
> 'All the stuff from here to the Else workes fine:
>
> 'Get Pref values into the UserForm
>
> 'SSB
>
> userform1.SB_Upper_Narrow = sheet1.Range ("SSB_Narrow_Upper_Pref").Value
>
> userform1.SB_Upper_Mid = sheet1.Range("SSB_Mid_Upper_Pref").Value
>
> userform1.SB_Upper_Wide = sheet1.Range("SSB_Wide_Upper_Pref").Value
>
> '...
>
> 'There is more of the same kind of setting here, not shown.
>
> '...
>
>
>
> userform1.Show ' When execution get here, this works.
>
>
>
> Else ' Abort the filter settings form
>
>
>
> MsgBox "Filter settings from this sheet are only for the TS-2000. To Change them, change the radio type to TS-2000 on the Memories sheet.", vbExclamation, " CAUTION CAUTION CAUTION"
>
>
>
> 'Now, Trouble. Activate the Memories sheet for the user to more easily make the change.
>
>
>
> Sheet3.Activate ' Adding this ONE line causes this CommandButton to become "crosshatched" when re-selecting Sheet1 !
>
>
>
> 'I've tried other things here like:
>
> 'End, or
>
> 'Reset, or
>
> 'PrefsButton.Activate to no avail.
>
>
>
> Exit Sub
>
> End If
>
>
>
> End Sub
>
> >-------------------------------------------------
>
>
>
> Sigh, Steve
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
.

__,_._,___
READ MORE....

[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 divider line.
>
> When, in Design Mode, I moved the button out of the frozen row and did the RightClick>CommandButton Object>Edit, it now shows as being selected (faint dotted line inside it and black, square, size-handles around the perimiter) and the cursor is at the beginning of the Caption allowing editing the Caption (obviously now in an edit mode).
> The conclusion, at least for this, being that Editing is disabled when the CommandButton is in the frozen row.
>
> Then...
> With the CommandButton out of the frozen row and trying normal operation (OUT of Design Mode), it now will function repeatedly (out of coma), when re-selecting the Sheet. It has the faint dotted box inside it indicating, I believe, that it has the Focus upon re-selecting the sheet.
>
> So ... this crosshatching (during my 'normal operation') is some sort of a symptom of being in a frozen top row...?
>
> Try 'freezing' your button... (no double meaning intended (;-0)
>
> Sheesh, Steve
>
> At least his keeps me off the streets at night, though this was pushing me in that direction. (;-D)
>
> --- "noskosteve" wrote:
> >
> > Tim,
> >
> > In its preference box it is called CommandButton. Adding annother button by: Developer>Controlls>ToolBox/Insert>ActiveX Controlls (that I must have used to place it originally) it appears to be an ActiveX CommandButton . It is the first choice in teh ActiveX section. There is just a button to click, no spin arrows.
> > (FWIW I never did understand the significance of ActiveX controls. I just try things and figure out how to use them...)
> >
> >
> > Here's an interesting turn of events that may give hints. As I looked around for more information on the CommandButton, I went into Design mode and right clicked the button. The resulting popup menu, among other things, had "CommandButton Object >". Selecting this showed "Edit". Selecting "Edit" then dismissed the popup and caused the SAME crosshatching! Try that...
> >
> > Then, left clicking on the button removed the crosshatching.
> > Right clicking also removed the crosshatching and brought up the ppropriate popup menu.
> >
> > Anything?...
> >
> > Regards, Steve
> >
> > --- Tim Lewis wrote:
> > >
> > > Steve, trying to get the same result, but I am not getting the same thing that you are seeing. The UserForm1.Sb... - are those spin buttons?
> > >
> > >
> > >
> > > From: noskosteve
> > > Sent: Friday, June 28, 2013 12:57 AM
> > >
> > >
> > > Maybe I should just take up knitting.
> > >
> > > Famous last words: Everything worked fine until...
> > >
> > > I have a Sheet1.CommandButton that normally brings up a UserForm for some preferences to be entered/changed by the user and works fine.
> > >
> > > I added a function which does not need these prefs. It's just a checkBox on Sheet3. When that function is activated, I bring up a message box indicating that the function must be disabled (unchecked) to see the Prefs' UserForm. Then, I exit the CommandButton_Click Sub without Showing the UserForm. Life is still good.
> > >
> > > Being the nice guy that I am, I figured it would be helpful to also automaticlly activate sheet3 which has the checkBox, so the user can easily un-check it and go back and see the UserForm to enter these prefs.
> > >
> > > Simply adding the Sheet3.Activate, causes the Sheet1.CommandButton to become crosshatched (when I reselect sheet1) in otder to to click it and enter the prefs.
> > > It is full of diagonal lines and unresponsive.
> > >
> > > When clicking the 'crossed-out' CommandButton, the crosshatch goes away, but it is now non-responsive. The Click Event does not fire the Click Sub.
> > > VBA doesn't appear to be paused or haulted in any way - other things work normally.
> > >
> > > Doing just about anything else that causes some other VBA code to execute then re-activates this catatonic CommandButton.
> > >
> > > Clicking the Reset button in the VBA window does not awaken the comatose CommandButton, nor change the title bar indicating VBA has changed modes (like going out of debug mode)
> > >
> > > FWIW here's the Click sub with the problem (near the end):
> > > ----------------------------------------------
> > > Private Sub PrefsButton_Click() ' Put filter prefs into Form
> > > Debug.Print "S_1 2 Filter Prefs Button Clicked. ";
> > >
> > > ' This sub is in Sheet1.
> > >
> > > ' Look at the ELSE for where the 'crosshatch' problem occurs...
> > >
> > > If Sheet3.Select_2000 Then ' The new function's CheckBox.
> > >
> > > ' All the stuff from here to the Else workes fine:
> > > ' Get Pref values into the UserForm
> > > ' SSB
> > > userform1.SB_Upper_Narrow = sheet1.Range("SSB_Narrow_Upper_Pref").Value
> > > userform1.SB_Upper_Mid = sheet1.Range("SSB_Mid_Upper_Pref").Value
> > > userform1.SB_Upper_Wide = sheet1.Range("SSB_Wide_Upper_Pref").Value
> > > ' ...
> > > ' There is more of the same kind of setting here, not shown.
> > > ' ...
> > >
> > > userform1.Show ' When execution get here, this works.
> > >
> > > Else ' Abort the filter settings form
> > >
> > > MsgBox "Filter settings from this sheet are only for the TS-2000. To change them, change the radio type to TS-2000 on the Memories sheet.", vbExclamation, " CAUTION CAUTION CAUTION"
> > >
> > > ' Now, Trouble. Activate the Memories sheet for the user to more easily make the change.
> > >
> > > Sheet3.Activate ' Adding this ONE line causes this CommandButton to become "crosshatched" when re-selecting Sheet1 !
> > >
> > > ' I've tried other things here like:
> > > ' End, or
> > > ' Reset, or
> > > ' PrefsButton.Activate to no avail.
> > >
> > > Exit Sub
> > > End If
> > >
> > > End Sub
> > > -------------------------------------------------
> > >
> > > Sigh, Steve
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
> [Non-text portions of this message have been removed]
>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (8)
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
.

__,_._,___
READ MORE....

[belajar-excel] Digest Number 2393

3 New Messages

Digest #2393
1a
Re: irisan by "Mr. Kid" nmkid.family@ymail.com
1b
Re: irisan by "Robby Hermawan" rbhtlkm99

Messages

Sun Jun 30, 2013 1:47 am (PDT) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Pake shape boleh gak ?
xixixixi....

2013/6/29 Lele Sinaga <sinaga_lontung@yahoo.co.id>

> **
>
>
> BeExceller,
> saya mau tanya.
> dari 1000pelari ada yang tinggi 200 orang yang sedang 500 orang yang
> pendek 300orang.
> gimanya buat irisan ketiga karakter ini.
> thanks
>
>
>

Sun Jun 30, 2013 2:28 am (PDT) . Posted by:

"Robby Hermawan" rbhtlkm99

Pake combine atau intersect jg bisa ;)

Emang ada ya irisan di excel ? Sesepuh master jabarin dong klo ada..

Delivered by Allah PowerISATberry

-----Original Message-----
From: "Mr. Kid" <mr.nmkid@gmail.com>
Sender: belajar-excel@yahoogroups.com
Date: Sun, 30 Jun 2013 15:46:39
To: BeExcel<belajar-excel@yahoogroups.com>
Reply-To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] irisan

Pake shape boleh gak ?
xixixixi....

2013/6/29 Lele Sinaga <sinaga_lontung@yahoo.co.id>

> **
>
>
> BeExceller,
> saya mau tanya.
> dari 1000pelari ada yang tinggi 200 orang yang sedang 500 orang yang
> pendek 300orang.
> gimanya buat irisan ketiga karakter ini.
> thanks
>
>
>

Sun Jun 30, 2013 2:59 am (PDT) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Wa'alaikumussalam Wr. Wb.

File terlampir menggunakan template formula.

Wassalamu'alaikum Wr. Wb.
Kid.

2013/6/27 ChordJR <vendeta_06@yahoo.co.id>

> **
>
>
> Assalamu'alaikum Wr. Wb.
>
> Selamat Sore Be-Excel,
> Langsung kepada topik pembicaraan, terdapat permasalahan pada Output
> yang saya buat yaitu pada Worksheet OverAll...bagan data awal adalah
> data pertama yang di ambil nilainya dari database (sheet Import)...dan
> bagan di bwh "data awal" adalah hasil copy secara manual dan formulanya
> secara manual juga...padahal datanya akan lebih banyak lagi...lebih
> jelas saya lampirkan filenya...
>
> Akibat data melebihi satu maka bagan tersebut menyesuaikan data yang ada
> pada sheet import secara otomatis pada saat saya klik Send Data pada
> sheet Import (VBA)...tolong jelaskan alurnya apa yang harus terlebih
> dahulu saya buat (step by step) mungkin sebelum vba di buat ^_^ itu juga
> kalo master berkenan memberikan penjelasannya...
>
> Ada gambaran sedikit dan saya coba buat record macronya tapi masih buntu
> juga harus bagaimana meng-aplikasikannya...Mohon bantuan Para Master
> Sekalian...Mohon maaf apabila penjelasan kurang di
> mengerti...Terimakasih banyak sebelumnya...
>
> Salam,
>
> Indra
>
>
GROUP FOOTER MESSAGE
=====================================================================
Untuk memudahkan tim penyusun materi Belajar Excel yang lebih sesuai kebutuhan member, silakan ungkapkan permasalahan yang kerap ditemui dalam menggunakan Excel sehari-hari atau hal-hal yang ingin dipelajari dalam jangka dekat ini. Mohon diprioritaskan dari yang sering ditemui sampai yang ingin dipelajari.
Isi sesuai kelompoknya (fitur-fitur, formula-formula tertentu yang masih membingungkan, otomasi atau pemrograman dalam Excel [Macro - VBA], hal lainnya yang membuat Anda kesulitan dalam mempelajari Excel).
Boleh mengisi berulang kali untuk menambah uneg-uneg yang ingin diungkapkan.
Link untuk menuangkan seluruh uneg-uneg tersebut ada di :
http://tech.groups.yahoo.com/group/belajar-excel/database?method=addRecord&tbl=3
=====================================================================
Langkah kecil Anda dalam mengisi database bisa menjadi langkah pertama yang bermanfaat besar untuk kita semua.
=====================================================================

---------------------------------------------------------------------
bergabung ke milis (subscribe), kirim mail kosong ke:
belajar-excel-subscribe@yahoogroups.com

posting ke milis, kirimkan ke:
belajar-excel@yahoogroups.com

berkunjung ke web milis
http://tech.groups.yahoo.com/group/belajar-excel/messages

melihat file archive / mendownload lampiran
http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di :
http://milis-belajar-excel.1048464.n5.nabble.com/

menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com

keluar dari membership milis (UnSubscribe):
kirim mail kosong ke  belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
READ MORE....