Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to set format "00000" in macro

Hi all, I want to use formula =text(Data in listbox,"00000000000000000") in macro but function is not defined

Here this is my code

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

Thank you

How to set format "00000" in macro

Hi all, I want to use formula =text(Data in listbox,"00000000000000000") in macro but function is not defineddefined. 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