How to set format "00000" in macro [closed]

asked 2019-09-23 05:24:47 +0100

Nina34 gravatar image

updated 2019-09-23 05:26:44 +0100

Hi all, I want to use formula =text(Data in listbox,"00000000000000000") in macro but function is not defined. I try to use format(text(MID_CODE),"00000000000000000") but it's not work, what should I do.

Here this is my code

MID_CODE = oMID_ListBx.Items(oMID_ListBx.ItemCount - 1)
MID_forSearch = text(MID_CODE,"00000000000000000")

Thank you

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Nina34
close date 2019-09-23 05:42:34.312715


I run again and MID_Search = Format(MID_CODE,"0000000000000000") is work

Nina34 gravatar imageNina34 ( 2019-09-23 05:42:21 +0100 )edit