This automatic email is posted to this group each month for the benefit of new members and as a reminder to current members. NOTICE VERSION: January, 2012 * This group is monitored by several moderators. In an effort to help weed out spammers, most posts are manually verified before they are released to the group. Therefore, if you are new to the group or do not regularly participate, it may take a bit longer for your post to show up in the group. This is normal. We do try to keep watch and release valid posts ASAP. Once you become a recognized/active member of the group, we try to make sure your membership is validated so that your posts can slide through without monitoring...
Jumat, 30 Juni 2017
[smf_addin] Digest Number 4075
EXCEL Stock Market Functions Add-in Group 2 Messages Digest #4075 1a Connecting to d.docs.live.net error by gwlunceford 1b Re: Connecting to d.docs.live.net error by "Randy Harmelink" ...
[belajar-excel] Digest Number 4223
Milis Belajar Microsoft Excel Group 2 Messages Digest #4223 1 multi pencarian menggunakan " * " ??? by shenly_excelmania 2.1 File - Peraturan Milis belajar-excel by ...
Re: Sv: [ExcelVBA] Display strings in messagebox (blank-sensitive)
Nice code Derek!! Not often you see Mid being used to replace characters! Lisa -----Original Message----- From: Derek Turner g4swy@yahoo.com [ExcelVBA] <ExcelVBA@yahoogroups.com> To: ExcelVBA <ExcelVBA@yahoogroups.com> Sent: Thu, Jun 29, 2017 2:43 pm Subject: Re: Sv: [ExcelVBA] Display strings in messagebox (blank-sensitive) Apologies for coming late to this thread but here is another way :- Function TrimReplace(sWord As String, Optional sReplacement As String = "*") As String Dim sFrame As String, nLTrimmedLength As Long sFrame = String(Len(sWord), sReplacement) If Not Trim(sWord)...
Sv: Sv: [ExcelVBA] Display strings in messagebox (blank-sensitive)
Derek, thank you for an elegant solution. I will definitely consider using this!These VBA-Groups are amazing, thanks!Torstein Den Torsdag, 29. juni 2017 14.43 skrev "Derek Turner g4swy@yahoo.com [ExcelVBA]" <ExcelVBA@yahoogroups.com>: Apologies for coming late to this thread but here is another way :-Function TrimReplace(sWord As String, Optional sReplacement As String = "*") As StringDim sFrame As String, nLTrimmedLength As Long sFrame = String(Len(sWord), sReplacement) If Not Trim(sWord) = "" Then nLTrimmedLength = Len(LTrim(sWord)) Mid(sFrame, Len(sWord)...
Kamis, 29 Juni 2017
[smf_addin] Digest Number 4074
EXCEL Stock Market Functions Add-in Group 4 Messages Digest #4074 1a Re: Yahoo History Array-Entered Help by for30sqn 1b Re: Yahoo History Array-Entered Help by "Randy Harmelink" ...