Jiangws's Blog

 
 
 
  • About

    夢を叶える為
 
INDIRECT formula to dynamically refer to another worksheet ->INDIRECT(“‘” & Sheet’s name & “‘!” & Cell to pull data from) May 16th, 2021

Excel INDIRECT function – basic uses and formula examples (ablebits.com)

Posted in VBA || Comments Off on INDIRECT formula to dynamically refer to another worksheet ->INDIRECT(“‘” & Sheet’s name & “‘!” & Cell to pull data from)
厨师长教你“西红柿炒蛋”的做法,美味多汁,先收藏起来 May 11th, 2021

(575) 厨师长教你“西红柿炒蛋”的做法,美味多汁,先收藏起来 – YouTube

Posted in LIFE || Comments Off on 厨师长教你“西红柿炒蛋”的做法,美味多汁,先收藏起来
Access combo box Set unique column but show other column and save other column May 11th, 2021
  1. Combo box : control souce -unique column, but set first column to the column you want to show(Other Column)
  2. Other column: set hide control and set the value when combo box change
Posted in Access || Comments Off on Access combo box Set unique column but show other column and save other column
Benefit for learning VBA May 2nd, 2021

Unlike macros, VBA enables you to do the following:

  • Work with complex logic structures (case statements, loops, and so on)
  • Take advantage of functions and actions not available in macros
  • Loop through and perform actions on recordsets
  • Perform transaction processing
Posted in VBA || Comments Off on Benefit for learning VBA
#煎马胶鱼这样才好吃​😋❤️ #Mackerel​ / #Tenggiri​ Ikan from Sabah Malaysia 🇲🇾 #马胶鱼的煮法 April 29th, 2021

(543) #煎马胶鱼这样才好吃😋❤️ #Mackerel / #Tenggiri Ikan from Sabah Malaysia 🇲🇾 #马胶鱼的煮法 – YouTube

Posted in LIFE || Comments Off on #煎马胶鱼这样才好吃​😋❤️ #Mackerel​ / #Tenggiri​ Ikan from Sabah Malaysia 🇲🇾 #马胶鱼的煮法
冬笋炒腊肉的做法,腊肉飘香,竹笋质嫩味鲜,清脆爽口 April 29th, 2021

(543) 冬笋炒腊肉的做法,腊肉飘香,竹笋质嫩味鲜,清脆爽口 – YouTube

Posted in LIFE || Comments Off on 冬笋炒腊肉的做法,腊肉飘香,竹笋质嫩味鲜,清脆爽口
小油菜這樣做,家常快捷,營養好吃下飯,色香味俱全 April 28th, 2021

(539) 小油菜這樣做,家常快捷,營養好吃下飯,色香味俱全 – YouTube

Posted in LIFE || Comments Off on 小油菜這樣做,家常快捷,營養好吃下飯,色香味俱全
醋溜大白菜 – 飯店的醋溜白菜,為啥那麼好吃,這一步很關鍵,酸辣開胃真下飯 April 28th, 2021

(539) 飯店的醋溜白菜,為啥那麼好吃,這一步很關鍵,酸辣開胃真下飯 – YouTube

醋溜大白菜 – 王刚的做法:
Posted in LIFE || Comments Off on 醋溜大白菜 – 飯店的醋溜白菜,為啥那麼好吃,這一步很關鍵,酸辣開胃真下飯
Chinese cabbage fried rice cakes, delicious and cheap, high nutritional value! April 27th, 2021

(539) 大白菜炒年糕,好吃又便宜,營養價值高! – YouTube

Posted in LIFE || Comments Off on Chinese cabbage fried rice cakes, delicious and cheap, high nutritional value!
〈 職人吹水〉 上海炒年糕 SHANGHAI RICE CAKE April 27th, 2021

(539) 〈 職人吹水〉 上海炒年糕 SHANGHAI RICE CAKE – YouTube

Posted in LIFE || Comments Off on 〈 職人吹水〉 上海炒年糕 SHANGHAI RICE CAKE