A few months ago when @theomarmukhtar got a double golden book entry for his excellent performance at school, we asked him what cake he wants to celebrate his outstanding achievements. I can still remember he instantaneously replied “Rainbow Cake”! Obviously I was surprised and asked him again to make sure that my 14 year old son really wanted a rainbow cake to celebrate his achievements. And without hesitation he confirmed “Yes, I want a rainbow cake!!” So Mr Dad went ahead and bought him the rainbow cake that he claimed that he ‘wants’. He only ate a slice of the cake and the rest was joyously enjoyed by his little brother and sister - Fatimah and Ali. I guess I do not need to explain further why he chose the cake. My selfless eldest son @theomarmukhtar has always put other people first before himself. Even to celebrate his achievements he still chose a cake that Fatimah and Ali would be enjoying more than him - bless him!
Last Friday, 2nd July was Ali’s 6th birthday. As you know, Ali’s been claiming that he is Fatimah’s twin and has been sharing Fatimah’s birthday ever since. So for his 6th birthday when Mr Dad asked Ali what cake he wants for his birthday, he secretly requested Mr Dad to surprise him with any cake but make sure the colour is pink cos whenever it’s his birthday it means that it will be Fatimah’s half birthday too and vice versa. So if you asked how close Fatimah and Ali are…well I can assure you that they are just like other normal siblings - they do fight and make up. But I guess there’s no need to prove how much they love one another cos at the end of the day, actions speak louder than words. And for this, I owe my biggest thank you to my #LuckyNumber1 @theomarmukhtar for setting the best example for your little brother and sister to follow.
May The Almighty protect all of our children’s hearts and make them love one another till their last breath and protect them all from the evil eye…
Blessed,
Mrs Mom - a mother blessed with 3 amazing children...sharing parenthood experience!
#wisemomsays
p/s: Happy 6th Birthday Ali & Happy 7 and a half Birthday Fatimah ♥️
#TheAccidentalTwins
luckynumber1 在 [算表] EXCEL VBA 取不重複的亂數- 看板Office - 批踢踢實業坊 的八卦
我用EXCEL的VBA
做了一個產生不重複的亂數程式
程式碼如下
Sub 按鈕1_Click()
Dim LuckyNumber() As Integer, Upperbound As Integer, Lowerbound As Integer,
ArrayLength As Integer, RndNumber As Integer, RndNumber2 As Integer, Temp As
Integer
Lowerbound = Range("D8").Value '從儲存格D8取亂數範圍的下限值
Upperbound = Range("D7").Value '從儲存格D7取亂數範圍的上限值
ArrayLength = Upperbound - Lowerbound
ReDim LuckyNumber(ArrayLength) As Integer
For i = 0 To ArrayLength
LuckyNumber(i) = Lowerbound + i
Next
Randomize
For j = 0 To ArrayLength
RndNumber = Int((Upperbound - Lowerbound + 1) * Rnd)
RndNumber2 = Int((Upperbound - Lowerbound + 1) * Rnd)
Temp = LuckyNumber(RndNumber)
LuckyNumber(RndNumber) = LuckyNumber(RndNumbber2)
LuckyNumber(RndNumbber2) = Temp
Next
End Sub
目前程式是可以產生出不重複的亂數值
我想呈現出來的結果是
按一下按鈕1的時候
在儲存格B3的位置
就顯示出LuckyNumber(0)的亂數結果
再按一下按鈕1的時候
同樣在B3的位置顯示
LuckyNumber(1)的亂數結果
以此類推
可是現在每按一次按鈕1
亂數陣列LuckyNumber()
就再重新產生一次了....
要如何讓亂數陣列固定下來
每按一次按鈕的時候
就顯示出下一個亂數
LuckyNumber(0)->LuckyNumber(1)->...LuckyNumber(N)
這個問題該怎麼解決？
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 123.51.218.120 (臺灣)
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1567069883.A.C47.html
... <看更多>