Hi,
I am trying to run macros for each item in combobox. These macros will insert text in a cell. The problem is that when i make a selection from combobox, save the file and reopen the file, it again runs the macro based on the value in combobox. I am getting the results twice in a cell.
I've written the following code.
Can you please tell how to avoid this problem..
Please Login or Register to view this content.
Hi, laxminarayana,
check the contents of the targeted cell by using Len or using IsEmpty and only then run macro?
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
How/when are you populating the combobox?
Also, if all the macros do is enter text based on what's selected couldn't it be done with one macro?
That macro could look at what's selected to determine what text to put in the cell.
If posting code please use code tags, see here.
Hi,
The text inserted by macros is combination of text and dates. I have attached my excel file can you please have a look.
Thank You
Hi, laxminarayana,
if you donīt want the data to double up you should not add the text to the data available in that cell but overwrite it.
Instead of
you could tryPlease Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks