ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] Àx¦s®æ¤ºªº¦h¬q¤å¦r¦r¦êÅܲÊ

[µo°Ý] Àx¦s®æ¤ºªº¦h¬q¤å¦r¦r¦êÅܲÊ

¦³¤@¥÷¤å¥óªí®æ¤º®eÃþ¦ü¤U­±±o±Ô­z,
¦]¬°Àx¦s®æ«Ü¦h,
§Ú·Q­n¥ÎVBAªº¤è¦¡§âÀx¦s®æ¤ºªº¦h¬q¤å¦r¦r¦êÅÜ²Ê ,
¨Ï¥Î InStr ³o­Ó¤½¦¡§ä¥X¦r¦ê¦ì¸m«á¥ÎCharacters(x, y).Font.Bold = True ¨Ó°µ,
²Ä¤@­Ó¦r¦ê¨S°ÝÃD,¦ý¬O¨ì²Ä¤G²Õ¦r¦ê,¤@ª½¦³°ÝÃD

¥D­n¬O·Q§â"4.2.2 FW version check" ³o¬q¾ã­ÓÅܲÊ
¥H¤U°£¤F«e­±½s¸¹¬OÅܼƥ~,«á­±¤å¦r¬O©T©wªº,
§Ú·Q§â³o¨Ç¤å¦r¥[½s¸¹ªº³¡¤À¤]ÅܲÊ,¤£ª¾¹D­n¦p¦ó¼gµ{¦¡¨Ó³B²z,
¯à§_¦³¤j¤j¥i¥HÀ°¦£­n¦p¼gµ{¦¡³B²z
4.2.2.1 Test Steps:
4.2.2.2 Test Command:
4.2.2.3 Test Command Feedback:
4.2.2.4 Pass Criteria:

Åܦ¨¦p¤UªºÅã¥Ü
4.2.2 FW version check

4.2.2.1 Test Steps:
Check product firmware version.

4.2.2.2 Test Command:

Test plan1.zip (6.53 KB)

G2 ¥i¹w¥ý¤U©Ô¨ì¦h®æ ¦pG99=IF(F2="","",IF(COUNTIFS(B$2:B2,B2,C$2:C2,C2,D$2:D2,D2)=1,IF(COUNTIFS(B$2:B2,B2,C$2:C2,C2)=1,"",LOOKUP(1,0/(B$1:B1=B2)/(C$2:C2=C2),G$1:G1)&"+")&D2&"("&F2&")",D2&"("&SUMIFS(F$2:F2,B$2:B2,B2,C$2:C2,C2,$D$2:D2,D2)&")"))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¥»©«³Ì«á¥Ñ stillfish00 ©ó 2019-12-4 17:53 ½s¿è

¦^´_ 1# wind6424
  1. Sub Test()
  2.     MyForm Sheets("Sheet1").[A2]
  3. End Sub
½Æ»s¥N½X
  1. Sub MyForm(rng As Range)
  2.     Dim text As String
  3.     Dim re As Object: Set re = CreateObject("vbscript.regexp")
  4.    
  5.     With re
  6.         .Pattern = "^\d+([.]\d+)+\s.*"
  7.         .MultiLine = True
  8.         .Global = True
  9.     End With
  10.     For Each cell In rng
  11.         text = cell.Value
  12.         For Each mch In re.Execute(text)
  13.             cell.Characters(Start:=mch.FirstIndex, Length:=mch.Length).Font.Bold = True
  14.         Next
  15.     Next
  16. End Sub
½Æ»s¥N½X
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

¦^´_ 2# hcm19522
·PÁ±zªº¨ó§U,¦ý¬O©êºp§Ú¬Ý¤£À´±zªº·N«ä?

TOP

¦^´_ 3# stillfish00
ÁÂÁ¤j¤j,§Ú¦b¸Õ¬Ý¬Ý
¥t¥~¥i¥H¸ò±z½Ð±Ð³o­Óµ{¦¡½X¤º .Pattern = "^\d+([.]\d+)+\s.*" «á­± ^\d+([.]\d+)+\s.* ³o¨Ç¦r¦êªº·N«ä?

TOP

¦^´_ 5# wind6424
½Ķ¹L¨Ó´N¬O¤Ç°t¶}ÀYªº²Ä¤@²Õ¦r¬O¥H¦Ü¤Ö¤@­Ó . ¤À¹j¼Æ¦rªº¦r²Õ¡C
¦³¿³½ì¥i¥H°Ñ¦Ò¤@¤U
http://www.study-area.org/coobila/tutorial_441.html
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

¥»©«³Ì«á¥Ñ wind6424 ©ó 2019-12-5 18:16 ½s¿è

¦^´_ 6# stillfish00
stillfish00 ¤j
±z³oºô§}Åý§Ú¦³§ä¨ìÄ_®wªº·Pı,
¯uªº«D±`·PÁ«üÂI.

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD