``` '得到随机字符串 Public Function getRndString(ByVal strKey$, ByVal intSize1%, Optional ByVal intSize2) As String Dim intRnd%, i%, s$, intLen% Randomize If IsMissing(intSize2) Then intRnd = intSize1 ElseIf intSize1 > intSize2 Then MsgBox "第1个参数不能比第2个参数大！", vbExclamation Exit Function ElseIf intSize1 = Val(intSize2) Then intRnd = intSize1 Else intRnd = Int(Rnd * (intSize2 - intSize1 + 1)) + intSize1 End If intLen = Len(strKey) For i = 1 To intRnd s = s & Mid(strKey, Int(intLen * Rnd) + 1, 1) Next getRndString = s End Function ``` **调用范例：** ``` '得到随机密码6~12位字符串 Public Function getRndPwd() As String Const C_RNDWORD$ = "abcdefghijklmnopqrstuvwxyz0123456789" getRndPwd = getRndString(C_RNDWORD, 6, 12) End Function '得到随机姓名 Public Function getRndName() As String Const C_Xing = "李王张刘陈杨赵黄周吴徐孙胡朱高林何郭马罗梁宋郑谢韩唐冯于董萧程曹袁邓许傅沈曾彭吕苏卢蒋蔡贾丁魏薛叶阎余潘杜戴夏钟汪田任姜范方石姚谭廖邹熊金陆郝孔白崔康毛邱秦江史顾侯邵孟龙万段钱汤尹黎易常武乔贺赖龚文第名庞兰殷施陶洪翟安颜倪严牛温芦季俞章鲁葛伍韦申尤毕聂丛焦向柳邢路岳齐沿梅莫庄辛管祝左涂谷祁时舒耿牟卜路詹关苗凌费纪靳盛童欧甄项曲成游阳裴席卫查屈鲍位覃霍翁隋植甘景薄单包司柏宁柯阮桂" Const C_Ming = "明国华建文平志伟东海强晓生光林小民永杰军波成荣新峰刚家龙德庆斌辉良玉俊立浩天宏子金健一忠洪江福祥中正振勇耀春大宁亮宇兴宝少剑云学仁涛瑞飞鹏安亚泽世汉达卫利胜敏群松克清长嘉红山贤阳乐锋智青跃元南武广思雄锦威启昌铭维义宗英凯鸿森超坚旭政传康继翔远力进泉茂毅富博霖顺信凡豪树和恩向道川彬柏磊敬书鸣芳培全炳基冠晖京欣廷哲保秋君劲栋仲权奇礼楠炜友年震鑫雷兵万星骏伦绍麟雨行才希彦兆贵源有景升惠臣慧开章润高佳虎根诚夫声冬奎扬双坤镇楚水铁喜之迪泰方同滨邦先聪朝善非恒晋汝丹为晨乃秀岩辰洋然厚灿卓轩帆若连勋祖锡吉崇钧田石奕发洲彪钢运伯满庭申湘皓承梓雪孟其潮冰怀鲁裕翰征谦航士尧标洁城寿枫革纯风化逸腾岳银鹤琳显焕来心凤睿勤延凌昊西羽百捷定琦圣佩麒虹如靖日咏会久昕黎桂玮燕可越彤雁孝宪萌颖艺夏桐月瑜沛杨钰兰怡灵淇美琪亦晶舒菁真涵爽雅爱依静棋宜男蔚芝菲露娜珊雯淑曼萍珠诗璇琴素梅玲蕾艳紫珍丽仪梦倩伊茜妍碧芬儿岚婷菊妮媛莲娟" getRndName = getRndString(C_Xing, 1) & getRndString(C_Ming, 1, 2) End Function ```