How to create a Boolean strings in excel with VBA Macro

[satish78]

Hi Friends,

I tried with a formula creating Boolean strings but its time consuming every time.
This is an example:
In Column, AI have list of words from A1:A50, It varies every time from A1:A50.
ColumnB AND words
ColumnC NOT words

Here I want to build Boolean strings in ColumnD.

In ColumnD, I need formula like this in image shown below while taking all keywords from A1:A50(sometimes A1:A9 or A1:A11 or A1;A13 or A1:A29 and so on) with "AND" and "NOT" words from respective columns(ColumnB and ColumnC)
Here I need Macro to display a popup box to input range of keywords(from ColumnA) to be present by default in each query/Boolean shown in image.

Suggestions would be highly appreciated.

https://spaces.hightail.com/space/Jfldl

 

[shg]

Yes, but that's what I have.

You can write a formula to catenate each row into a single string.